Getting Started

Using Postico

Troubleshooting

More Information

You are looking at the documentation for Postico v1.5.21 — would you like to go to the latest version instead?

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:

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.

Interaction with other applications

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.

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: