Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Karsten Hilbert <Karsten.Hilbert@xxxxxxx> 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.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux