Postico App Icon Postico 2

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:

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: