psql

Use psql to interact with PostgreSQL databases.

Common Commands

Connection

• Connect: psql "postgresql://user:password@host:port/dbname"
• Connect with env var: psql "${DATABASE_URL}"

Inspection

• List databases: \l
• List tables: \dt
• Describe table: \d <table_name>
• List schemas: \dn