List the databases on a PostgreSQL/PgSQL server
Contributed by Rex 
December 16, 2003 
Tagged: PostgreSQL PgSQL
From within the psql monitor, use the following command to list all of the databases in the server:
\l
Alternatively, you can list the databases from the command line using:
psql -l