Re: [GENERAL] How to retrieve the comment for a constraint?

2005-03-24 Thread Tom Lane
Wolfgang Drotschmann <[EMAIL PROTECTED]> writes: > Now, imagine you know the name of a constraint or all of them for a given > table, e.g. destilled via > SELECT * > FROM information_schema.table_constraints >WHERE table_name = ''; > How can I get the comment for each of thes

[GENERAL] How to retrieve the comment for a constraint?

2005-03-24 Thread Wolfgang Drotschmann
Hallo all, using at least PostgreSQL 7.4.2, one can use the command COMMENT ON CONSTRAINT ON ; to document a constraint defined via CONSTRAINT ... in the context of a table. Now, imagine you know the name of a constraint or all of them for a given table, e.g. destilled via SELEC