martinjw / dbschemareader

Read database metadata (from SqlServer/Oracle/MySql/SQLite/PostgreSql/DB2 etc) into one simple model
Microsoft Public License
293 stars 128 forks source link

PostgreSQL table script generator, incorrect default text value #157

Closed r-work closed 1 year ago

r-work commented 1 year ago

It seems to add an extra single quote at the end which causes syntax error, like the following example (note the single quote after the text type):

CREATE TABLE public.global_settings
(
  id BIGINT NOT NULL,
  time_format TEXT  DEFAULT 'HH:mm'::text'
)
martinjw commented 1 year ago

https://github.com/martinjw/dbschemareader/releases/tag/2.8.0.0