Re: Custom type

From: Bryce Nesbitt <bryce1(at)obviously(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Custom type
Date: 2006-03-22 21:07:33
Message-ID: 4421BC95.1030005@obviously.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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::

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Daniel Caune 2006-03-22 21:10:30 Re: Custom type
Previous Message Terry Lee Tucker 2006-03-22 20:41:13 Re: Custom type