wiki:Postgres HowTo useful commands

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'

Last modified 6 years ago Last modified on 08/30/16 12:19:10
Note: See TracWiki for help on using the wiki.