Re: SQL to list databases?

From: Keith Keller <kkeller-postgres(at)wombat(dot)san-francisco(dot)ca(dot)us>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL to list databases?
Date: 2003-01-23 22:43:41
Message-ID: 20030123224341.GA7721@wombat.san-francisco.ca.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Jan 23, 2003 at 12:56:50PM -0600, Ben Siders wrote:
>
> Is there a query that will return all the databases available, similar
> to what psql -l does?

Any time you wish to know what psql is doing with ''meta'' commands
(like the \ commands), use the -E switch, which will display the queries
it's sending to the backend. man psql for more details.

--keith

--
kkeller(at)speakeasy(dot)net
public key: http://wombat.san-francisco.ca.us/kkeller/kkeller.asc
alt.os.linux.slackware FAQ: http://wombat.san-francisco.ca.us/cgi-bin/fom

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message David Durst 2003-01-24 00:16:52 Scheduling Events?
Previous Message Wei Weng 2003-01-23 22:01:51 Rename database?