Postico

User Guide

Getting Started

• Get started with Postgres.app
• Connecting to a local PostgreSQL server

Using Postico

• Working with Favorites
• Using Connection URLs
• Importing and Exporting data
• Using the table DDL view
• Autosaving Queries
• Keyboard Shortcuts

Troubleshooting

• Common Connection Problems
• Reporting Bugs

More Information

• Changelist
• Security Features
• Automatic Update Checking
• Automatic Crash Reporting
• Acknowledgements
• License Terms

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)

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:

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