fworks-tech 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
Queries
- Execute query:
psql -c "SELECT * FROM table LIMIT 10" "${DATABASE_URL}" - Execute from file:
psql -f migration.sql "${DATABASE_URL}" - Quit:
\q
Notes
- Requires
psqlinstalled. SetDATABASE_URLenvironment variable for connection string.