Re: [SQL] Question on SQL and pg_-tables

2002-11-27 Thread Peter Childs
On Wednesday 27 November 2002 10:13, Tilo Schwarz wrote: > > Tilo Schwarz <[EMAIL PROTECTED]> 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 eas

Re: [SQL] Question on SQL and pg_-tables

2002-11-27 Thread Tilo Schwarz
> Tilo Schwarz <[EMAIL PROTECTED]> 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 >

Re: [SQL] Question on SQL and pg_-tables

2002-11-25 Thread Tom Lane
Tilo Schwarz <[EMAIL PROTECTED]> 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 t