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] ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend