Обсуждение: 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

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,

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 |
SEQUENCEobject_name | TRIGGER trigger_name ON table_name | TYPE object_name | VIEW object_name 
} IS 'text'

I believe this is what you need.

HTH.

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 descriptionsSchema |    Name    | Object |       Description
--------+------------+--------+-------------------------public | db_version | table  | Managed in nautilus.xml

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

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 relationsSchema |           Name           | Type  |  Owner   |
Description
 
--------+--------------------------+-------+----------+-------------public | fffg                     | table |
postgres| the rainpublic | 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)

george young <gry@ll.mit.edu> writes:
> 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...

No, because that Description column is for comments on the individual
columns.
        regards, tom lane