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