Ivan Radovanovic <radovanovic@gmail.com> writes:
> I was checking for way to get object comments, and it seems that \dd has
> bug when it comes to extracting descriptions for constraints.
That code looks right to me, and it works according to a simple test:
d1=# create table foo (f1 int primary key);
CREATE TABLE
d1=# comment on constraint foo_pkey on foo is 'here is a comment';
COMMENT
d1=# \dd
Object descriptions
Schema | Name | Object | Description
--------+----------+------------+-------------------
public | foo_pkey | constraint | here is a comment
(1 row)
What exactly do you think the problem is?
regards, tom lane