snippets > basic-commands-postgresql-psql

Basic commands for navigating psql command line (PostgreSQL)

psql -U $POSTGRES_USER $POSTGRES_DB
\l # list databases
\c # select a database
\d # list tables
\d+ <table_name> # describe table