List Databases

To see databases on the postgresql instance you’re connected to (similar to a mysql show databases):


This will list the DB Name, Owner, Encoding, Collate, Ctype and Access privileges.

To connect to a database called “dbname” here for example, you would enter the following:

\c dbname

Now if we want to list tables in dbname, after connected we would type: