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.
π Check out our easy to use desktop GUI for SQL
Beekeeper Studio is a truly cross-platform SQL GUI with a clean, uncluttered interface. Write SQL, edit data, alter tables, and more!
Available for MacOS, Linux, and Windows.
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
ββββ+βββ-+βββ-+ββββ+ββββ+βββββββ