Re: comment on COLUMN, broken or misunderstanding?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bryce Nesbitt <bryce1(at)obviously(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: comment on COLUMN, broken or misunderstanding?
Date: 2008-02-18 02:35:03
Message-ID: 5750.1203302103@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Bryce Nesbitt <bryce1(at)obviously(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Bertheau 2008-02-18 02:39:51 Re: comment on COLUMN, broken or misunderstanding?
Previous Message Bryce Nesbitt 2008-02-18 02:18:26 comment on COLUMN, broken or misunderstanding?