Re: 'show databases' in psql way? - Mailing list pgsql-sql

FromIan Barwick
SubjectRe: 'show databases' in psql way?
Date
Msg-id[email protected]
Whole thread Raw
In response to'show databases' in psql way?  (Erik Wasser <[email protected]>)
ResponsesRe: 'show databases' in psql way?
Listpgsql-sql
On Mon, 1 Nov 2004 13:13:10 +0100, Erik Wasser <[email protected]> wrote:
> Hi list,
> 
> how can I list the databases in a postgresish way? I know about the '-l'
> switch of 'psql' but is there a DBI/SQL-query way? I don't want to call
> an external program only to list the databases. I've googled about this
> problem but I only found the '-l'-way to this this.
> 
> Ideas? Solutions?

Start psql with the -E switch, and it shows the SQL used to generate
the output from psql's slash commands.

Ian Barwick
[email protected]


pgsql-sql by date:

Previous
From: Frank Bax
Date:
Subject: Re: 'show databases' in psql way?
Next
From: Erik Wasser
Date:
Subject: Re: 'show databases' in psql way?