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.
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 Database GUI
Best SQL query & editor tool I have ever used. It provides everything I need to manage my database. - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studio is fast, intuitive, and easy to use. Beekeeper supports loads of databases, and works great on Windows, Mac and Linux.
What Users Say About Beekeeper Studio
"Beekeeper Studio completely replaced my old SQL workflow. It's fast, intuitive, and makes database work enjoyable again."
"I've tried many database GUIs, but Beekeeper strikes the perfect balance between features and simplicity. It just works."