Re: postgres 7.0.2 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: postgres 7.0.2
Date
Msg-id 9330.966964007@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres 7.0.2  (Thomas Swan <tswan-lst@tangent.ics.olemiss.edu>)
List pgsql-hackers
Thomas Swan <tswan-lst@tangent.ics.olemiss.edu> writes:
> Actually, I think I understand the question.  The original person wants to 
> be able to do a query and get a result containing a list of 
> databases.   AFAIK, there isn't a way to do this using standard SQL-like 
> statements.  Somebody correct me if I'm wrong.

SELECT datname FROM pg_database;

I think Tim's real gripe is about having to know enough about the
contents of the system tables to be able to construct such a query.
        regards, tom lane


pgsql-hackers by date:

Previous
From: hstenger@adinet.com.uy
Date:
Subject: Re: How Do You Pronounce "PostgreSQL"?
Next
From: Tim Perdue
Date:
Subject: Re: postgres 7.0.2