PostgreSQL – List Databases

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

</>
Copy
\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