Re: Custom type

> > 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,
>
> From the \h command in psql:
>
> rnd=# \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.
>

I see!  I was searching an option in the custom type creation statement,
something like:
 CREATE TYPE foo (   ... ) DESCRIPTION "something that might be useful";

Thanks for this information!

--
Daniel