From: Terry Lee Tucker <terry@esc1.com>
Organization: Enhanced Solutions Computing
To: <pgsql-sql@postgresql.org>
Subject: Re: Custom type
Date: Wed, 22 Mar 2006 15:41:13 -0500
User-Agent: KMail/1.5.3
References: <1E293D3FF63A3740B10AD5AAD88535D201D654AE@UBIMAIL1.ubisoft.org>
In-Reply-To: <1E293D3FF63A3740B10AD5AAD88535D201D654AE@UBIMAIL1.ubisoft.org>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200603221541.13089.terry@esc1.com>


On Wednesday 22 March 2006 03:25 pm, Daniel Caune saith:
> Hi,
>
> How can I enter description for my custom types?
>
> \dT provides information such as schema, name, and description for all
> the registered types and custom types.  I would like to provide a
> description for each custom type I create.
>
> Thanks,
>
>
> --
> Daniel CAUNE
> Ubisoft Online Technology
> (514) 4090 2040 ext. 5418
>

Daniel,

=46rom the \h command in psql:

rnd=3D# \h comment
Command:     COMMENT
Description: define or change the comment of an object
Syntax:
COMMENT ON
{
  TABLE object_name |
  COLUMN table_name.column_name |
  AGGREGATE agg_name (agg_type) |
  CONSTRAINT constraint_name ON table_name |
  DATABASE object_name |
  DOMAIN object_name |
  FUNCTION func_name (arg1_type, arg2_type, ...) |
  INDEX object_name |
  OPERATOR op (leftoperand_type, rightoperand_type) |
  RULE rule_name ON table_name |
  SCHEMA object_name |
  SEQUENCE object_name |
  TRIGGER trigger_name ON table_name |
  TYPE object_name |
  VIEW object_name
} IS 'text'

I believe this is what you need.

HTH.