drawdb
drawdb copied to clipboard
[BUG] Postgres UNLOGGED tables not recognized on "Import from SQL"
Describe the bug Postgres unlogged tables are a common optimization trick for transient steps in ETL/ELT jobs. A workaround is of course to remove the UNLOGGED part, but tedious.
Thus this DDL should work:
CREATE UNLOGGED TABLE t1 (
id integer PRIMARY KEY,
data text
);
To Reproduce Steps to reproduce the behavior:
- Go to 'Import from SQL'
- Select the above detailed schema file
- Click "Import"
- See error:
https://github.com/taozhi8833998/node-sql-parser/issues/2382