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:
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: