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 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org