Re: 'show databases' in psql way?

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