This is an old revision of the document!
PostgreSQL
Commands
Open Shell
psql -d palliabackend -U palliabackend
Import data
psql -d palliabackend -U palliabackend < test_data/foobar.sql
Shell commands
- Connect to database:
\c dbname username - List databases:
\l - List tables:
\dt - Describe table:
\d table_name - List schemas of current database:
\dn - List users:
\du - Command history:
\s - Quit shell:
\q