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

From Ian Barwick
Subject Re: 'show databases' in psql way?
Date
Msg-id 1d581afe041101042611fd649c@mail.gmail.com
Whole thread Raw
In response to 'show databases' in psql way?  (Erik Wasser <erik.wasser@iquer.net>)
Responses Re: 'show databases' in psql way?  (Erik Wasser <erik.wasser@iquer.net>)
List pgsql-sql
On Mon, 1 Nov 2004 13:13:10 +0100, Erik Wasser <erik.wasser@iquer.net> 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
barwick@gmail.com


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?