Using the Table DDL View

The DDL (data definition language) view renders the SQL statements necessary to re-create the selected table/view from scratch. It also works if the table is new, or changes are made in the Structure editor. In case of pending changes, the DDL view renders multiple sections:

SQL statements to create the current version
SQL statements to to perform the pending changes
SQL statements to create a preview of the final version (pending changes applied)

Known Limitations

Postico does not support all database features. The DDL view is not intended for backup purposes. Please use pg_dump for backups.

Postico tries to simplify the SQL for better readability:

Schema qualification is skipped if the schema name is public
Tablespace declaration is skipped if the tablespace name is pg_default