Date: Fri, 24 Mar 2006 15:07:03 -0500
From: george young <gry@ll.mit.edu>
To: pgsql-sql@postgresql.org
Subject: Re: Custom type
Message-Id: <20060324150703.5254c23f.gry@ll.mit.edu>
In-Reply-To: <4421BC95.1030005@obviously.com>
References: <1E293D3FF63A3740B10AD5AAD88535D201D654AE@UBIMAIL1.ubisoft.org>
	<200603221541.13089.terry@esc1.com>
	<4421BC95.1030005@obviously.com>
Reply-To: gry@ll.mit.edu
Organization: MIT Lincoln Laboratory
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

On Wed, 22 Mar 2006 13:07:33 -0800
Bryce Nesbitt <bryce1@obviously.com> threw this fish to the penguins:

> Terry Lee Tucker wrote:
> > rnd=# \h comment
> > Command:     COMMENT
> > Description: define or change the comment of an object
> > ..I believe this is what you need.
> >   
> Cool!
> That's a great feature.  Though it would be even nicer if the comment
> showed when
> you "\d" a table::

Hmm, it does(in 8.1.0) if you just say  "\d+" without an argument:
newschm3=# comment on table fffg is 'the rain';
newschm3=# \d+
                         List of relations
 Schema |           Name           | Type  |  Owner   | Description 
--------+--------------------------+-------+----------+-------------
 public | fffg                     | table | postgres | the rain
 public | group_run_limit          | table | postgres | 
 public | hold_log                 | table | postgres | 
...

But not if you specify the object:

newschm3=#  \d+ fffg
            Table "public.fffg"
 Column |  Type   | Modifiers | Description 
--------+---------+-----------+-------------
 t      | text    |           | 
 i      | integer |           | 

This seems a bit like a bug to me...

-- George Young

> stage=# comment on table db_version is 'Managed in nautilus.xml';
> stage=# \d db_version
> 
>           Table "public.db_version"
>  Column  |         Type          | Modifiers
> ---------+-----------------------+-----------
>  version | character varying(64) |
> 
> 
> stage=# \dd db_version
> 
>                   Object descriptions
>  Schema |    Name    | Object |       Description
> --------+------------+--------+-------------------------
>  public | db_version | table  | Managed in nautilus.xml
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 


-- 
"Are the gods not just?"  "Oh no, child.
What would become of us if they were?" (CSL)