postgresqlHow do I list all databases in PostgreSQL?
To list all databases in PostgreSQL, you can run the following command:
\l
This will return a list of all databases available in the PostgreSQL server. The output will look something like this:
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+------------+------------+-----------------------
postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 |
template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)
The command \l
is an alias for the \list
command. This command can take an optional parameter pattern
to filter the list of databases by name. For example, to list only databases that start with the letter a
, you can use the following command:
\l a%
This will output only the databases that start with the letter a
.
For more information, please refer to the PostgreSQL Documentation.
More of Postgresql
- How do I use the PostgreSQL to_char function?
- How do I set up PostgreSQL replication?
- How can I find the median value using PostgreSQL?
- How do I view PostgreSQL logs?
- How do I download the PostgreSQL JDBC driver?
- How do I use the PostgreSQL hash function?
- How can I use PostgreSQL with YAML?
- How can I retrieve data from PostgreSQL for yesterday's date?
- How can I troubleshoot zero damaged pages in PostgreSQL?
- How can I monitor PostgreSQL performance using Zabbix?
See more codes...