Re: Question on SQL and pg_-tables

Поиск
Список
Период
Сортировка
От Tilo Schwarz
Тема Re: Question on SQL and pg_-tables
Дата
Msg-id 200211271113.40827.mail@tilo-schwarz.de
обсуждение исходный текст
Ответ на Re: Question on SQL and pg_-tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Question on SQL and pg_-tables  (Peter Childs <Blue.Dragon@blueyonder.co.uk>)
Список pgsql-sql
> Tilo Schwarz <mail@tilo-schwarz.de> writes:
> > - Is it possible to get not only the two tables, but also their
> > corresponding two columns involved in a RI-Constraint out of the pg_*
> > tables just with a SQL query?
>
> Not easily --- the column info is buried in the pg_trigger.tgargs entries
> for the RI triggers, which there is no good way to take apart in plain SQL.
>
> You might care to start experimenting with 7.3 instead; the new
> pg_constraint table makes this much easier.

Thank you, I'll check that out.

Regards,
Tilo


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

Предыдущее
От: Luis Sousa
Дата:
Сообщение: Re: SQL query help!
Следующее
От: Laurent Patureau
Дата:
Сообщение: Function and insert