Table of Contents

PostgreSQL
- Commands
  - Open Shell
  - Import data
- Shell commands

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