til / useful postgres commands

Useful Postgres commands and queries that I tend forget.

PSQL #

• \c databaseName - Connect to a database
• \dt - List all tables (relations)

Queries #

-- Create a comma separated list of all values of an enum
SELECT ENUM_RANGE(NULL::enum_name)

Command line #

# Standard database dump
pg_dump -h host -U user databasename > filename.sql

# Only export the data, not the database structure
pg_dump -h host -U user --data-only databasename > filename.sql

# Create a tar archive
pg_dump -h host -U user -F t databasename > filename.tar