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:
There are three table views (Content / Structure / DDL). To navigate, select the required table view in the "Navigate" menu or use the segmented button at the bottom. There's also a keyboard shortcut (⌥⌘T) to cycle between the table views.
To copy selected sections to the clipboard, simply use the command "Copy" in the context menu.
Alternatively, you can use the "Save Query…" button to save the whole buffer to a file.
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:
publicpg_default