Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id AE758475E41
	for <pgsql-sql@postgresql.org>; Thu, 23 Jan 2003 23:42:05 -0500 (EST)
Received: from heimdall (KTPP-p-203-54-180-90.prem.tmns.net.au
 [203.54.180.90])
	by postgresql.org (Postfix) with ESMTP id B364E4771D3
	for <pgsql-sql@postgresql.org>; Thu, 23 Jan 2003 21:58:20 -0500 (EST)
Received: from heimdall (heimdall [127.0.0.1])
	by heimdall (Postfix) with ESMTP id 111128006F
	for <pgsql-sql@postgresql.org>; Fri, 24 Jan 2003 13:58:15 +1100 (EST)
From: Horst Herb <hherb@gnumed.net>
To: pgsql-sql@postgresql.org
Subject: Re: SQL to list databases?
Date: Fri, 24 Jan 2003 13:58:14 +1100
User-Agent: KMail/1.5
References: <81132473206F3A46A72BD6116E1A06AE1B14CC@black.aprote.com>
	<26610.1043341252@sss.pgh.pa.us> <3E303AF2.10603@cms-stl.com>
In-Reply-To: <3E303AF2.10603@cms-stl.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200301241358.14785.hherb@gnumed.net>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/468
X-Sequence-Number: 11333

On Fri, 24 Jan 2003 05:56, you wrote:
> Is there a query that will return all the databases available, similar
> to what psql -l does?

select * from pg_database;

Horst