[HACKERS] How do I get a list of DB's or Tables with a postgres SQL statement?

See the pg_database table: http://www.postgresql.org/idocs/index.php?catalog-pg-database.html Regards, Lee. Ron de Jong writes: > All, > > How do I get a list of DB's or Tables with a postgres SQL statement? > It needs to be an SQL statement otherwise perl/DBI/prepare won't parse it. > I

[HACKERS] How do I get a list of DB's or Tables with a postgres SQL statement?

All, How do I get a list of DB's or Tables with a postgres SQL statement? It needs to be an SQL statement otherwise perl/DBI/prepare won't parse it. I know there is some funtions in psql: \l(show databases) \d(show tables) which work fine from psql, but these statements won't be parsed

Re: [HACKERS] How do I get a list of DB's or Tables with a postgres SQL statement?

Ron de Jong wrote: > I know there is some funtions in psql: > > \l(show databases) > \d(show tables) If you start psql with the -E option, it will show you which queries it makes to the internal tables to retrieve the backslash result. Then copying and customizing your own query is very