PostgreSQL List all databases

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

Now run

This will list all available databases.

To change to a database, use command /connect

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

PostgreSQL Create Database

To create a database, run

Creating user, grant permissions

Creating a User and Database using psql