Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 76793479C12 for ; Thu, 23 Jan 2003 18:26:08 -0500 (EST) Received: from polaris.pinpointresearch.com (66-7-238-176.cust.telepacific.net [66.7.238.176]) by postgresql.org (Postfix) with ESMTP id 34F9F477695 for ; Thu, 23 Jan 2003 16:24:48 -0500 (EST) Received: from there (66-7-238-179.cust.telepacific.net [66.7.238.179]) by polaris.pinpointresearch.com (Postfix) with SMTP id 75146103E6; Thu, 23 Jan 2003 13:24:49 -0800 (PST) Content-Type: text/plain; charset="iso-8859-1" From: Steve Crawford Organization: Pinpoint Research To: Ben Siders , pgsql-sql@postgresql.org Subject: Re: SQL to list databases? Date: Thu, 23 Jan 2003 13:24:49 -0800 X-Mailer: KMail [version 1.3.1] 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-Transfer-Encoding: 8bit Message-Id: <20030123212449.75146103E6@polaris.pinpointresearch.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/376 X-Sequence-Number: 11241 psql -E causes psql to show it's "behind the scenes" queries to try: psql -lE (that's a lower case ell before the E) Cheers, Steve On Thursday 23 January 2003 10:56 am, Ben Siders wrote: > Is there a query that will return all the databases available, similar > to what psql -l does? > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org