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