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

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: svanegmond(at)home(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: comments on columns aren't displayed by \dd
Date: 2001-03-20 05:23:04
Message-ID: 200103200523.AAA27697@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Thomas LockhartDate: 2001-03-20 05:36:04
Subject: Re: Patch application
Previous:From: pgsql-bugsDate: 2001-03-20 05:15:28
Subject: comments on columns aren't displayed by \dd

pgsql-bugs by date

Next:From: Stephen van EgmondDate: 2001-03-20 05:56:25
Subject: Re: comments on columns aren't displayed by \dd
Previous:From: pgsql-bugsDate: 2001-03-20 05:15:28
Subject: comments on columns aren't displayed by \dd

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