PostgreSQL list databasesIT technician command center
● ITSign inMembers
Database · SQL and Database Administration

PostgreSQL list databases

List PostgreSQL databases in psql.

Copy-ready commandPostgreSQL list databases
\l

Requirements and permissions

Requirements
Appropriate database client and connection
Permissions
Database privileges vary
Last reviewed
2026-07-31

Examples

Basic example

List PostgreSQL databases in psql.

\l

Common errors

Command not found

Confirm Appropriate database client and connection is installed and available in your current shell.