comment on constraint

Andreas Kretschmer <akretschmer@spamfence.net> wrote:

There is a question in the german pg-forum:

It is possible to add a comment on a constraint, but \dd doesn't display
that comment. There is also a old question in this mailing-list without
an answer:
http://archives.postgresql.org/pgsql-general/2003-07/msg01448.php

I think, this is a bug, isn't it?

Why? The man page for psql clearly says:

| \dd[S] [ pattern ]
| Shows the descriptions of objects matching the
| pattern, or of all visible objects if no argu-
| ment is given. But in either case, only objects
| that have a description are listed. By default,
| only user-created objects are shown; supply a
| pattern or the S modifier to include system ob-
| jects. ‘‘Object’’ covers aggregates, functions,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| operators, types, relations (tables, views, in-
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| dexes, sequences), large objects, rules, and
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| triggers. [...]
^^^^^^^^^
So no comments are shown for constraints or table columns
or ...

Tim

Andreas Kretschmer wrote:

Hi,

There is a question in the german pg-forum:

It is possible to add a comment on a constraint, but \dd doesn't display
that comment. There is also a old question in this mailing-list without
an answer:
http://archives.postgresql.org/pgsql-general/2003-07/msg01448.php

I think, this is a bug, isn't it?

Yep, added to TODO:

Allow \dd to show constraint comments

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com
  PG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do
  + If your life is a hard drive, Christ can be your backup. +