Ubuntu/postgres

Login as root

~$ sudo su - postgres
~$ psql
postgres=#

List databases

List all DBs

postgres=# \list -OR- \l

List all tables in current DB

postgres=# \dt 

Connect to DB

postgres=# \connect <database name>