From: | "Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com> |
---|---|
To: | "Terry Lee Tucker" <terry(at)esc1(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Custom type |
Date: | 2006-03-22 21:10:30 |
Message-ID: | 1E293D3FF63A3740B10AD5AAD88535D201D6557C@UBIMAIL1.ubisoft.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> > 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-03-22 21:53:48 | Re: [SQL] Function Parameters in GROUP BY clause cause errors |
Previous Message | Bryce Nesbitt | 2006-03-22 21:07:33 | Re: Custom type |