logo-MindMajix
k
kavya A

Posted on 22nd July 2024|45 views

0
votes

Postgresql List Databases

How to List databases in PostgreSQL?

1 answers
Answers
P
jordan chris

Posted on 22nd July 2024| 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.

 

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
Name
Course *
Email *
Phone Number