wiki:Postgres HowTo useful commands

Version 3 (modified by Richard Bramley, 8 years ago) ( diff )

--

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'

Note: See TracWiki for help on using the wiki.