PostgreSQL List all databases

To list all databases in the PostgreSQL database, first connect to the PostgreSQL database using psql command

su - postgres
psql

Now run

\list

This will list all available databases.

To change to a database, use the command /connect

\connect DBNAME

Once you are connected to a database, you can list all tables in a database with the command

\dt