December 24, 2022 By Matthew Rathbone *

In PostgreSQL, the equivalent of the SHOW DATABASES command in MySQL is the \l command. This command is used to list all of the databases on the current PostgreSQL server.

A Database Manager That Is Modern, Fast, & Easy To Use

Tried a few tools. Beekeeper was the only one that I found that felt right. Most had a very 1990's feel to them - Allan

I built Beekeeper Studio because, like Allan, I wanted something more intuitive and modern than all the existing clunky apps I could find. My customers agree - they love using Beekeeper and they tell me every day! Give it a try, I bet you'll like it too.

Beekeeper's Linux version is 100% full-featured, no cut corners, no feature compromises.

To use this command, simply connect to your PostgreSQL server using the psql command-line interface, and then enter \l at the prompt. This will display a list of all of the databases on the server, along with some additional information such as the owner of the database and the encoding used.

Postgres SHOW DATABASES Example

For example, if you have two databases named mydb1 and mydb2, the output of the \l command might look something like this:

postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges