Extracting database metadata

Поиск
Список
Период
Сортировка
От Grzegorz Mucha
Тема Extracting database metadata
Дата
Msg-id 01061312012500.02593@theta
обсуждение исходный текст
Список pgsql-general
Is there somewhere a solution that would list PG metadata? Most things are
simple to do, though foreign key information is not that trivial.
Regarding FKeys(as they interest me the most), I only noticed that they
can be extracted from pg_trigger, though the form the data are written
makes it difficult to do something with it in SQL or PLpgSQL (at least for
me).
I'd appreciate if someone shared his solution with me (perhaps a query or
a stored procedure that would extract FK data in tabular form - with table
and column names as columns)

--
Grzegorz Mucha <mucher@tigana.pl> ICQ #91619595, tel.(502)261417
----------------------------------------------------------------

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Re: Does PostgreSQL support EXISTS?
Следующее
От: "Andy Samuel"
Дата:
Сообщение: Vacuum-ing without disconnecting users