\l

Category: Databases & SQL

\l

List all databases on the server

Prints every database with its owner, encoding, and access privileges. \l+ adds sizes and descriptions, and psql -l does the same from the shell. Related: \c to switch into one of them.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.