Thread: Viewing Foreign key constraints in psql
Hi: 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. Thank you , ludwig __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com
hi all, I am accessing postgresql-7.1.3 from C with asynchronous query processing. If by any chance the backend crashes, is there any means to know in C that the backend has crashed. Querying from pqsocket doesn't help. Can anybody throw light on it. Thanx in advance. -- regards, hari
Ludwig Lim <lud_nowhere_man@yahoo.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