Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com> writes:
> How do I view the foreign key constraints (name and
> definition) in psql? I can only see the triggers
> created by the constraint when I use the "\d <table>"
> command in psql.
In PG versions < 7.3, you don't: the system doesn't retain any concept
of the foreign key constraint as such, only the triggers that implement
it. In 7.3 there is a pg_constraint table with an actual entry for each
foreign key constraint.
regards, tom lane