PostgreSQL show databases 2017-10-17 07:27
In PostgreSQL there are two ways to list all databases.
- Use command
\list or \l can list all databases. In my environment the output is like following.
user=# \l
List of databases
Name | Owner | Encoding | Collation | Ctype | Access privileges
-----------+----------+-----------+-----------+-------+-----------------------
user | postgres | SQL_ASCII | C | C |
postgres | postgres | SQL_ASCII | C | C |
template0 | postgres | SQL_ASCII | C | C | =c/postgres
: postgres=CTc/postgres
template1 | postgres | SQL_ASCII | C | C | =c/postgres
: postgres=CTc/postgres
(4 rows)
- Use sql
You can also use sql to show the name of databases.
blog=# SELECT datname FROM pg_database WHERE datistemplate = false;
datname
----------
postgres
user
(2 rows)
EOF