Postgres HowTo useful commands

Tags: Postgres HowTo

Log in to database

psql -d mydb -U myuser

Log in to no database

psql -d postgres -U myuser

List Databases

\l

Switch Databases

\c dbname

List Tables

\dt

Exit Command Line

\q

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'