Re: [GENERAL] list databases with SQL command

2005-01-18 Thread Richard Huxton
David Teran wrote: Hi, maybe its a silly question, but is there a way to list all databases with an SQL command? I know about the \l command from psql, but i wonder if such things are possible with SQL. Look into the pg_class table or the information schema. Also, if you start psql with -E then y

Re: [GENERAL] list databases with SQL command

2005-01-18 Thread Peter Eisentraut
Am Dienstag, 18. Januar 2005 11:32 schrieb David Teran: > maybe its a silly question, but is there a way to list all databases > with an SQL command? I know about the \l command from psql, but i > wonder if such things are possible with SQL. SELECT * FROM pg_database; -- Peter Eisentraut http://