Posted on 29th April 2025|45 views
How to List databases in PostgreSQL?
Posted on 29th April 2025| views
You can use psql command to run the command \l or \list to list all the PostgreSQL databases in the current PostgreSQL database server.
Or in detail,
I suggest you run this query to list all the databases:
SELECT datname FROM pg_database;
Or
You can see all the databases through GUI by using the TablePlus.