Postgres Pro
Downloads
Home   >   mailing lists

Re: Database names and pg_dump - Mailing list pgsql-novice

From Tom Lane
Subject Re: Database names and pg_dump
Date
Msg-id 16984.1061934259@sss.pgh.pa.us
Whole thread Raw
In response to Database names and pg_dump  (David Rickard <David.Rickard@GTScompanies.com>)
List pgsql-novice
Tree view 
David Rickard <David.Rickard@GTScompanies.com> writes:
> Is there an equivalent file or utility that will provide the name of each
> database within a PostGreSQL cluster?

SELECT datname FROM pg_database;

            regards, tom lane

pgsql-novice by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Database names and pg_dump
Next
From: Juan Francisco Diaz
Date:
Subject: Returning a setof integer