Re: 'show databases' in psql way?

From: Ian Barwick <barwick(at)gmail(dot)com>
To: Erik Wasser <erik(dot)wasser(at)iquer(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: 'show databases' in psql way?
Date: 2004-11-01 12:26:56
Message-ID: 1d581afe041101042611fd649c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, 1 Nov 2004 13:13:10 +0100, Erik Wasser <erik(dot)wasser(at)iquer(dot)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(at)gmail(dot)com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Erik Wasser 2004-11-01 12:33:12 Re: 'show databases' in psql way?
Previous Message Frank Bax 2004-11-01 12:23:54 Re: 'show databases' in psql way?