PostgreSQL: \list

List all databases

• https://www.postgresql.org/docs/13/app-psql.html

Examples:

• \l
• \l+
• \list
• \list+
• \list your-db-beggining-with*
• -l
• --list

Examples

PostgreSQL 16 (Sep 2023)
                                               List of databases
   Name    | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-----------+-------+----------+-----------------+---------+-------+------------+-----------+-------------------
 postgres  | user  | UTF8     | libc            | C       | C     |            |           |
 template0 | user  | UTF8     | libc            | C       | C     |            |           | =c/user          +
           |       |          |                 |         |       |            |           | user=CTc/user
 template1 | user  | UTF8     | libc            | C       | C     |            |           | =c/user          +
           |       |          |                 |         |       |            |           | user=CTc/user
 your-db   | user  | UTF8     | libc            | C       | C     |            |           |
(4 rows)

postgres-> \list
                                       List of databases
   Name    |   Owner    | Encoding |   Collate   |    Ctype    |       Access privileges
-----------+------------+----------+-------------+-------------+-------------------------------
 YOUR_DB | rds_master | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/rds_master               +
           |            |          |             |             | rds_master=CTc/rds_master   
 rdsadmin  | rdsadmin   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | rdsadmin=CTc/rdsadmin
 template0 | rdsadmin   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/rdsadmin                  +
           |            |          |             |             | rdsadmin=CTc/rdsadmin
 template1 | rds_master | UTF8     | en_US.UTF-8 | en_US.UTF-8 | rds_master=CTc/rds_master    +
           |            |          |             |             | =c/rds_master
(4 rows)

completePostgresql=>  \list
                                                       List of databases
        Name        |        Owner        | Encoding |   Collate   |    Ctype    |              Access privileges
--------------------+---------------------+----------+-------------+-------------+---------------------------------------------
 completePostgresql | complete_postgresql | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 postgres           | complete_postgresql | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 rdsadmin           | rdsadmin            | UTF8     | en_US.UTF-8 | en_US.UTF-8 | rdsadmin=CTc/rdsadmin                      +
                    |                     |          |             |             | rdstopmgr=Tc/rdsadmin
 template0          | rdsadmin            | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/rdsadmin                                +
                    |                     |          |             |             | rdsadmin=CTc/rdsadmin
 template1          | complete_postgresql | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/complete_postgresql                     +
                    |                     |          |             |             | complete_postgresql=CTc/complete_postgresql
(5 rows)

Related terms

• List users: \du
• List tables: \dt or \dt *.*
• \c YourDBName
• \z YourTable
• DROP DATABASE
• CREATE DATABASE
• PostgreSQL Privileges
• \connect
• PostgreSQL template databases
• SELECT datname FROM pg_database WHERE datistemplate = false;

See also

• PostgreSQL Privileges, GRANT, \list+, \du+
• CREATE DATABASE