Re: Question on SQL and pg_-tables

From: Tilo Schwarz <mail(at)tilo-schwarz(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Question on SQL and pg_-tables
Date: 2002-11-27 10:13:40
Message-ID: 200211271113.40827.mail@tilo-schwarz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> Tilo Schwarz <mail(at)tilo-schwarz(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Laurent Patureau 2002-11-27 11:05:11 Function and insert
Previous Message Luis Sousa 2002-11-27 10:05:24 Re: SQL query help!