On 08/21/13 16:34, Ivan Radovanovic napisa:
On 08/21/13 16:03, Tom Lane napisa:
Ivan Radovanovic<radovano...@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
Problem is if you create table in schema other than public (I am not
sure if \dd should show comments only for objects in public schema, I
assumed not?)
db=# create schema test;
CREATE SCHEMA
db=# create table test.foo (f1 int primary key);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey"
for table "foo"
CREATE TABLE
db=# comment on constraint foo_pkey on test.foo is 'here is a comment';
COMMENT
db=# \dd
Object descriptions
Schema | Name | Object | Description
--------+------+--------+-------------
(0 rows)
Obviously there is optional pattern argument for \dd which would show
comments in different schema, so I it was my mistake after all.
Sorry for false alarm
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
