From: george young <gry@ll.mit.edu>
To: pgsql-sql@postgresql.org
Subject: Re: Custom type
Date: Fri, 24 Mar 2006 15:07:03 -0500
Message-ID: <20060324150703.5254c23f.gry@ll.mit.edu> (raw)
In-Reply-To: <4421BC95.1030005@obviously.com>
References: <1E293D3FF63A3740B10AD5AAD88535D201D654AE@UBIMAIL1.ubisoft.org>
<200603221541.13089.terry@esc1.com>
<4421BC95.1030005@obviously.com>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gry@ll.mit.edu
Subject: Re: Custom type
In-Reply-To: <20060324150703.5254c23f.gry@ll.mit.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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