PostgreSQL – List Databases

To get the list of PostgreSQL Databases, open psql shell and run the list command as shown below.

\l

In the following PostgreSQL shell, when we run the list databases command, the output is a table with the name of database, owner of database, database encoding, and other details.

PostgreSQL List Databases