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.
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.
Before you keep reading, I just wanted to let you know about our open source PostgreSQL GUI, Beekeeper Studio. It lists every database on your server in a dropdown at the top of its sidebar, so switching between them takes one click, and it’s free to use for PostgreSQL, download it here.
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
———–+———-+———-+————+————+——————–
Beekeeper Studio Is A Free & Open Source PostgreSQL GUI
This is the PostgreSQL client I’ve been looking for! The UI is what sets it apart: Clean, intuitive, powerful. Goodbye clunky PGAdmin. - David Cyprian
Beekeeper Studio is a fast, intuitive and easy to use PostgreSQL client. It supports loads of other databases too, and works great on Windows, Mac and Linux.
What PostgreSQL Users Say About Beekeeper Studio
Unlike pgAdmin, Beekeeper is remarkably simple to use yet not lacking in features–and the price is right! The database backup feature is particularly useful. Just great software.
Fabulous tool, the most practical IDE I’ve found to date for Postgres and MySql db admin - it just works, no fuss :-)