====== 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''