Showing posts with label db. Show all posts
Showing posts with label db. Show all posts

Thursday, March 24, 2011

Get list of all databases in PostgreSQL

In mySQL we use following query to get the list:
SHOW DATABASES ;.
In PostgreSQL we should use :
SELECT datname FROM pg_database;