Useful Commands

PreviousNext

Quick reference for common PostgreSQL commands

Useful Commands

Connect to Database

# macOS
psql zooly2_local

# Windows
psql -U postgres -d zooly2_local

List All Databases

# macOS
psql -l

# Windows
psql -U postgres -l

Backup Database

# macOS
pg_dump zooly2_local > backup.sql

# Windows
pg_dump -U postgres zooly2_local > backup.sql

Restore Database

# macOS
psql zooly2_local < backup.sql

# Windows
psql -U postgres zooly2_local < backup.sql