PostgreSQL

psql commands

Login

PGPASSWORD="$PASSWORD" psql -h "$HOST" -p "$PORT" -U "$USERNAME" -d "$DATABASE"

Display Tables

\dt

Describe a Table

\d table_name

SELECT

SELECT column_1, column_2
FROM "Table"
WHERE column_1 = 'mega_iphone_release_1';