첫번째 방법
[postgres@pg-00:/var/lib/pgsql]$ psql -l
Null display is "NULL".
Timing is off.
Pager usage is off.
SQL> \l+
Name | Owner | Encoding | Collate | Ctype |
-----------+--------------+----------+---------+-------+
dksmc | ksmcadm | UTF8 | C | C |
| | | | |
| | | | |
| | | | |
| | | | |
edb | enterprisedb | UTF8 | C | C |
perf | mig | UTF8 | C | C |
postgres | enterprisedb | UTF8 | C | C |
powa | powa | UTF8 | C | C |
template0 | enterprisedb | UTF8 | C | C |
template1 | enterprisedb | UTF8 | C | C |
test | enterprisedb | UTF8 | C | C |
(8 rows)
두번째 방법
postgres@[local]:5432:postgres]
SQL> select datname from pg_database;
datname
-----------
postgres
edb
template0
test
powa
template1
perf
dksmc
(8 rows)
postgres@[local]:5432:postgres]
SQL>