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;

No comments:

Post a Comment