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]