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


Read More…

PostgreSQL Create Database

To create a database, run

Creating user, grant permissions

Creating a User and Database using psql


Read More…