Once you are on postgres=# prompt, you need to type the following commands to see the list of databases and tables.
- \list or \l: to list all databases
- \dt or \d : to list all tables in the current database
To connect to a particular database: \connect database_name (e.g. \connect myproject). Once you are connected to a particular database, \dt or \d to list all tables in the current database.