Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Markus BertheauDate: 2008-02-18 02:39:51
Subject: Re: comment on COLUMN, broken or misunderstanding?
Previous:From: Bryce NesbittDate: 2008-02-18 02:18:26
Subject: comment on COLUMN, broken or misunderstanding?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group