Re: SQL to list databases? - Mailing list pgsql-sql

From Keith Keller
Subject Re: SQL to list databases?
Date
Msg-id 20030123224341.GA7721@wombat.san-francisco.ca.us
Whole thread Raw
In response to SQL to list databases?  (Ben Siders <bsiders@cms-stl.com>)
List 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@speakeasy.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



pgsql-sql by date:

Previous
From: "Wei Weng"
Date:
Subject: Rename database?
Next
From: Steve Crawford
Date:
Subject: Re: SQL to list databases?