How to list databases in PostgreSQL

Hi,

You can do all these with the psql prompt of postgresql.

change user to postgres

su - postgres

The open psql tool by typing psql on the console:

psql

Now you can list the database names with the '\l' command. Here is example of listing databases in postgresql database server. List databases on the server:

\l

Then connect to database with the command:

\c template1

Thanks