Re: how to find foreign key details (column, that is)

On Sun, Dec 14, 2008 at 02:37:51PM -0500, Tom Lane wrote:
> Subject: Re: [GENERAL] how to find foreign key details (column, that is)
>
> Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> writes:
> > I cannot, however, for the life of it find out how to learn
> > the *column* the foreign key is on.
>
> pg_constraint.conkey has the referencing columns' numbers.

Tom, thanks, as usual awesome support on the 3rd Sunday in
Advent ...

This is what my 8.3 manual says:

conkey │ int2[] │ pg_attribute.attnum │ If a table constraint, list of columns which the constraint constrains │

From that I wouldn't have figured it'd apply to foreign keys
as well. So I assume it is fair to say that "foreign keys
are one type of table constraint", right ?

Thanks again,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346