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

Tom Lane wrote:
> Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> writes:
> > 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 ?
>
> Right. I think what the comment is actually trying to point out is that
> conkey isn't relevant to domain constraints, which also appear in
> pg_constraint.

Can someone come up with better documention wording for conkey? I
can't:

http://developer.postgresql.org/pgdocs/postgres/catalog-pg-constraint.html

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +