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 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 by perl, DBI
>
> I also know there is an object:
>
> @names = $dbh->tables;
>
> but what about databases?
>
> Please help.
>
> Ron de Jong
> the Netherlands
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html