Re: postgres 7.0.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Swan <tswan-lst(at)tangent(dot)ics(dot)olemiss(dot)edu>
Cc: Tim Perdue <tim(at)sourceforge(dot)net>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)hub(dot)org
Subject: Re: postgres 7.0.2
Date: 2000-08-22 17:06:47
Message-ID: 9330.966964007@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Swan <tswan-lst(at)tangent(dot)ics(dot)olemiss(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Roderick A. Anderson 2000-08-22 17:19:17 I lied! [Solved] SQL Server to PostgreSQL
Previous Message Dominic J. Eidson 2000-08-22 17:04:27 Re: postgres 7.0.2