k
kavya A

Posted on 4th March 2024|41 views

0
votes

Postgresql List Databases

How to List databases in PostgreSQL?

Answers
P
jordan chris

Posted on 4th March 2024

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.

 

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo
  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos