PostgreSQL 18 · Inspecting the database
List databases
Show every database on the server. Run \l inside psql or use the flag from the shell.
psql -U postgres -l
Official PostgreSQL 18 documentation
More inspecting the database commands
All inspecting the database commands · PostgreSQL 18 cheatsheet