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