Integrity Relationships

Поиск
Список
Период
Сортировка
От rob
Тема Integrity Relationships
Дата
Msg-id 000801c05743$1e291c90$4100fd0a@cabrion.org
обсуждение исходный текст
Список pgsql-general
Given a table name, is there a way to query one or more system tables to
determine what other tables it references via foreign keys?  The opposite
would work just as well (i.e. what other tables reference the given table).
I've looked at pg_triggers and there seems to be an attribute (trigger
arguments?)  that has the table names, but I don't know how to parse the
data correctly.

TIA,

--rob


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Warning: Don't delete those /tmp/.PGSQL.* files
Следующее
От: GH
Дата:
Сообщение: Re: Warning: Don't delete those /tmp/.PGSQL.* files