Re: newbie needs help with postgres internal tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: newbie needs help with postgres internal tables
Дата
Msg-id 9655.1006542897@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: newbie needs help with postgres internal tables  (William WAISSE <wwaisse@esprit-equipe.fr>)
Ответы Re: newbie needs help with postgres internal tables
Список pgsql-general
William WAISSE <wwaisse@esprit-equipe.fr> writes:
>  It's necessary cause I want to display in a treeview ( GtkCtree ) all the
> the tables in a particular database, and for each table, all the fields in
> this table ).

You can only see tables of the database you are connected to.  To do the
above, you'd need to open a connection to each database in turn
(assuming that the installation is configured to let you get into all of
them...)

pg_database is visible from all databases, and so are pg_shadow and
pg_group, but AFAIR everything else is database-local.

            regards, tom lane

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

Предыдущее
От: Luis Amigo
Дата:
Сообщение: explain analyze
Следующее
От: Luis Amigo
Дата:
Сообщение: enable_nestloop