Re: comments on columns aren't displayed by \dd

Psql manual pages says:

The command form \d+ is identical, but any comments
associated with the table columns are shown as
well.

> Stephen van Egmond (svanegmond(at)home(dot)com) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> comments on columns aren't displayed by \dd
>
> Long Description
> Comments on columns appear to be broken. CREATE COMMENT ON COLUMN inserts stuff into the backend pg_* tables correctly. However \dd from the psql interactive monitor doesn't send a query to retrieve it (i.e. no join on pg_attribute).
>
> I am working from the Debian package postgresql-client 7.0.3-2.
>
> Sample Code
> create table foo (a text);
> cmment on column foo.a is 'hello!';
> \dd foo.a
>
> No file was uploaded with this report
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026