psql -l

according to handbook

example output:

 List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -------------+--------+----------+-------------+-------------+------------------- packrd | packrd | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | packrd | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | packrd | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/packrd + | | | | | packrd=CTc/packrd template1 | packrd | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/packrd + | | | | | packrd=CTc/packrd (5 rows) 

From the command-line: psql -l

Or from the psql interface: \l

Example output:

 List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -------------+--------+----------+-------------+-------------+------------------- packrd | packrd | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | packrd | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | packrd | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/packrd + | | | | | packrd=CTc/packrd template1 | packrd | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/packrd + | | | | | packrd=CTc/packrd (5 rows) 

psql -l according to handbook

psql -l

according to handbook

example output:

 List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -------------+--------+----------+-------------+-------------+------------------- packrd | packrd | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | packrd | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | packrd | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/packrd + | | | | | packrd=CTc/packrd template1 | packrd | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/packrd + | | | | | packrd=CTc/packrd (5 rows)