Re: Question on SQL and pg_-tables - Mailing list pgsql-sql

From Tom Lane
Subject Re: Question on SQL and pg_-tables
Date
Msg-id 8774.1038249125@sss.pgh.pa.us
Whole thread Raw
In response to Question on SQL and pg_-tables  (Tilo Schwarz <mail@tilo-schwarz.de>)
Responses Re: Question on SQL and pg_-tables  (Tilo Schwarz <mail@tilo-schwarz.de>)
List 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.
        regards, tom lane


pgsql-sql by date:

Previous
From: Tilo Schwarz
Date:
Subject: Question on SQL and pg_-tables
Next
From: "Michael Richards"
Date:
Subject: changing the size of a column without dump/restore