Thread

1. how to see column comments?

   Norman Clarke <norman@combimatrix.com> — 2001-02-16T01:24:19Z

   Hello,
   
   I have not been able to get psql to show column comments in version
   7.1beta4. Am I doing anything wrong, or is this a bug? A transcript of my
   psql session is below.
   
   Norm
   
   ------------------------------------------------------------------
   
   
   norman=# create table test_table (col1 integer);
   
   CREATE
   
   norman=# comment on table test_table is 'this is a table comment';
   
   COMMENT
   
   norman=# \dd test_table
   
                   Object descriptions
       Name    |   Object    |       Description
   ------------+-------------+-------------------------
    test_table | relation(r) | this is a table comment
   (1 row)
    
   norman=# comment on column test_table.col1 is 'this is a column comment';
   
   COMMENT
   
   norman=# \dd test_table.col1
   
        Object descriptions
    Name | Object | Description
   ------+--------+-------------
   (0 rows)
   
   
   

2. Re: how to see column comments?

   Christopher Sawtell <csawtell@xtra.co.nz> — 2001-02-16T03:42:43Z

   You have to put the actual name (attribute) of the column, not "col1"
   
   On Fri, 16 Feb 2001 14:24, Norman J. Clarke wrote:
   > Hello,
   >
   > I have not been able to get psql to show column comments in version
   > 7.1beta4. Am I doing anything wrong, or is this a bug? A transcript of
   > my psql session is below.
   >
   > Norm
   >
   > ------------------------------------------------------------------
   >
   >
   > norman=# create table test_table (col1 integer);
   >
   > CREATE
   >
   > norman=# comment on table test_table is 'this is a table comment';
   >
   > COMMENT
   >
   > norman=# \dd test_table
   >
   >                 Object descriptions
   >     Name    |   Object    |       Description
   > ------------+-------------+-------------------------
   >  test_table | relation(r) | this is a table comment
   > (1 row)
   >
   > norman=# comment on column test_table.col1 is 'this is a column
   > comment';
   >
   > COMMENT
   >
   > norman=# \dd test_table.col1
   >
   >      Object descriptions
   >  Name | Object | Description
   > ------+--------+-------------
   > (0 rows)
   
   -- 
   Sincerely etc.,
   
    NAME       Christopher Sawtell
    CELL PHONE 021 257 4451
    ICQ UIN    45863470
    EMAIL      csawtell @ xtra . co . nz
    CNOTES     ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
   
    -->> Please refrain from using HTML or WORD attachments in e-mails to me 
   <<--