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

Поиск
Список
Период
Сортировка
От Ron de Jong
Тема How do I get a list of DB's or Tables with a postgres SQL statement?
Дата
Msg-id 9qjr1g$rle$1@reader05.wxs.nl
обсуждение исходный текст
Ответы How do I get a list of DB's or Tables with a postgres SQL statement?  (Lee Kindness <lkindness@csl.co.uk>)
Список pgsql-hackers
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







В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: ecpg - GRANT bug
Следующее
От: Denis A Ustimenko
Дата:
Сообщение: Re: compiling libpq++ on Solaris with Sun SPRO6U2 (fixed