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

Setting up Postgres.app

Installing Postgres.app

Postgres.app is by far the easiest way to install a local PostgreSQL server on your Mac.

• Download Postgres.app from http://postgresapp.com
• Double click

Postgres.app starts a PostgreSQL server running locally on your Mac. The first time it starts it will automatically create a new data directory and set up an empty database. After a few moments, the server will be running and waiting for connections.

Postgres.app can't start when another PostgreSQL server is already running on your computer. If you run into problems, make sure to deactivate or uninstall other PostgreSQL installations. Reboot your computer after uninstalling!

Connecting to Postgres.app

• Open Postico and click on the “New Favorite” button.
  Leave all fields blank; the default values are suitable for connecting to Postgres.app. Optionally provide a nickname, eg. “Postgres.app”.
• Click “Connect”

DONE! You should now see a mostly empty database window. There is an “SQL Query” icon you can use to execute queries, and buttons in the bottom bar allow you to create tables and views.