Postgres Pro
Downloads
Home   >   mailing lists

Re: comment on COLUMN, broken or misunderstanding? - Mailing list pgsql-sql

From Tom Lane
Subject Re: comment on COLUMN, broken or misunderstanding?
Date
Msg-id 5750.1203302103@sss.pgh.pa.us
Whole thread Raw
In response to comment on COLUMN, broken or misunderstanding?  (Bryce Nesbitt <bryce1@obviously.com>)
List pgsql-sql
Tree view 
Bryce Nesbitt <bryce1@obviously.com> writes:
> I'm expecting COLUMN comments to work much like table comments, but I'm
> getting nothing back.  Is this a reportable bug, or a misunderstanding?

> # comment on column sched.days is 'Bitmask 0=Sunday,7=Holiday, 8=School
> day, 9=Special';
> COMMENT
> # \dd sched.days;
>  Schema | Name | Object | Description
> --------+------+--------+-------------
> (0 rows)

Try "\d+ sched".  I don't think \dd considers columns at all --- what
that command would be looking for is comments on table days in schema
sched.

        regards, tom lane

pgsql-sql by date:

Previous
From: Bryce Nesbitt
Date:
Subject: comment on COLUMN, broken or misunderstanding?
Next
From: "Markus Bertheau"
Date:
Subject: Re: comment on COLUMN, broken or misunderstanding?