Re: 'show databases' in psql way?

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: 'show databases' in psql way?
Date: 2004-11-01 12:23:54
Message-ID: 5.2.1.1.0.20041101072247.03e4c3c0@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

At 07:13 AM 11/1/04, Erik Wasser wrote:
>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.

The -e switch of psql will display queries behind commands. So use this
option, the use 'l' as a command instead of a switch.

Frank

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ian Barwick 2004-11-01 12:26:56 Re: 'show databases' in psql way?
Previous Message Erik Wasser 2004-11-01 12:13:10 'show databases' in psql way?