pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedcomment on COLUMN, broken or misunderstanding?
5+ messages / 5 participants
[nested] [flat]
* comment on COLUMN, broken or misunderstanding?
@ 2008-02-18 02:18 Bryce Nesbitt <bryce1@obviously.com>
0 siblings, 4 replies; 5+ messages in thread
From: Bryce Nesbitt @ 2008-02-18 02:18 UTC (permalink / raw)
To: pgsql-sql
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)
# comment on table sched is 'Table comment';
COMMENT
ez-sched=# \dd sched;
Object descriptions
Schema | Name | Object | Description
--------+-------+--------+---------------
public | sched | table | Table comment
(1 row)
# select * from version();
PostgreSQL 8.2.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.1
(SUSE Linux)
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: comment on COLUMN, broken or misunderstanding?
@ 2008-02-18 02:35 Tom Lane <tgl@sss.pgh.pa.us>
parent: Bryce Nesbitt <bryce1@obviously.com>
3 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2008-02-18 02:35 UTC (permalink / raw)
To: Bryce Nesbitt <bryce1@obviously.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: comment on COLUMN, broken or misunderstanding?
@ 2008-02-18 02:39 Markus Bertheau <mbertheau.pg@googlemail.com>
parent: Bryce Nesbitt <bryce1@obviously.com>
3 siblings, 0 replies; 5+ messages in thread
From: Markus Bertheau @ 2008-02-18 02:39 UTC (permalink / raw)
To: Bryce Nesbitt <bryce1@obviously.com>; +Cc: pgsql-sql
2008/2/18, Bryce Nesbitt <bryce1@obviously.com>:
> 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?
Try \d+ sched
Markus
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: comment on COLUMN, broken or misunderstanding?
@ 2008-02-18 02:50 Milen A. Radev <milen@radev.net>
parent: Bryce Nesbitt <bryce1@obviously.com>
3 siblings, 0 replies; 5+ messages in thread
From: Milen A. Radev @ 2008-02-18 02:50 UTC (permalink / raw)
To: pgsql-sql
Bryce Nesbitt написа:
> 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?
[...]
Misunderstanding I would say - "\dd" is for objects and they are:
'"Object" covers aggregates, functions, operators, types, relations
(tables, views, indexes, sequences, large objects), rules, and
triggers.' (http://www.postgresql.org/docs/8.2/static/app-psql.html,
look for "\dd").
You could see the comment for the column with "\d+ table_name".
--
Milen A. Radev
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: comment on COLUMN, broken or misunderstanding?
@ 2008-02-18 04:38 Michael Fuhr <mike@fuhr.org>
parent: Bryce Nesbitt <bryce1@obviously.com>
3 siblings, 0 replies; 5+ messages in thread
From: Michael Fuhr @ 2008-02-18 04:38 UTC (permalink / raw)
To: Bryce Nesbitt <bryce1@obviously.com>; +Cc: pgsql-sql
On Sun, Feb 17, 2008 at 06:18:26PM -0800, Bryce Nesbitt wrote:
> 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)
You're using the wrong psql command. Try "\d+ sched".
--
Michael Fuhr
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-02-18 04:38 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-18 02:18 comment on COLUMN, broken or misunderstanding? Bryce Nesbitt <bryce1@obviously.com>
2008-02-18 02:35 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-02-18 02:39 ` Markus Bertheau <mbertheau.pg@googlemail.com>
2008-02-18 02:50 ` Milen A. Radev <milen@radev.net>
2008-02-18 04:38 ` Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox