postgreslisted

# 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 `psql` installed. Set `DATABASE_URL` environment variable for connection string.