Andrew McDonough

Please note: This page is imported from my wiki, which hasn't been updated in over 10 years. Some of the formatting was lost during the import. I'll try to get around to fixing it someday.

Postgres

Logging in:

su - postgres psql

Common Commands

\dt - show tables \l - show databases \d

- describe table

Command line tools

Dump database

pg_dump >file


Andrew McDonough

Andrew McDonough is a consultant CTO and software developer, currently based between Berlin and London.

Follow Andrew on Twitter or Connect on LinkedIn