COMMENT

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES 注æ
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
è¯è
è·

---

NAME

COMMENT - å®ä¹æèæ¹åä¸ä¸ªå¯¹è±¡çè¯æ³¨

SYNOPSIS

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’

DESCRIPTION æè¿°

COMMENT åå¨ä¸ä¸ªæ°æ®åºå¯¹è±¡çè¯æ³¨ï¼ è¿ä¸ªè¯æ³¨å¯ä»¥å¾å®¹æç¨ psql ç \dd, \d+, å \l+ å½ä»¤æ£ç´¢åºæ¥ã å¶å®æ£ç´¢è¯æ³¨çç¨æ·æ¥å£å¯ä»¥å»ºè®¾å¨ psql æç¨å°åæ ·å°åé¨å½æ°çåºç¡ä¸ï¼ ä¹å°±æ¯ obj_description() å col_description()ã

è¦ä¿®æ¹ä¸ä¸ªè¯æ³¨ï¼ä¸ºåä¸ä¸ªå¯¹è±¡ååºä¸æ¡æ°ç COMMENT å½ä»¤å³å¯ãæ¯ä¸ªå¯¹è±¡åªåå¨ä¸æ¡è¯æ³¨ã è¦å é¤è¯æ³¨ï¼å¨ææ¬å串çä½ç½®åä¸ NULLã å½å é¤å¯¹è±¡æ¶ï¼è¯æ³¨èªå¨è¢«å é¤æã

PARAMETERS åæ°

object_name
table_name.column_name
aggname
constraint_name
func_name

op

rule_name
trigger_name

è¦å å¥è¯æ³¨ç对象å称ã表ï¼ç´¢å¼ï¼åºåï¼è§å¾ï¼ç±»åï¼åï¼å½æ°ï¼ èéåæä½ç¬¦çååå¯ä»¥æ¯æ¨¡å¼ä¿®é¥°çã

agg_type

èéå½æ°çåæ°ç±»åï¼å¦æå½æ°æ¥åä»»ææ°æ®ç±»åï¼é£ä¹æ¯ *ã

large_object_oid

大对象ç OIDã

PROCEDURAL

è¿ä¸ªåæ ç¨ã

sourcetype

ç±»å转æ¢çæºæ°æ®ç±»åååã

targettype

ç±»å转æ¢çç®çæ°æ®ç±»åååã

text

æ°çè¯æ³¨ã

NOTES 注æ

ä¸ä¸ªæ°æ®åºéçè¯æ³¨åªè½å¨æ¹æ°æ®åºéå建ï¼å¹¶ä¸åªæå¨é£ä¸ªæ°æ®åºéå¯è§ï¼å¶å®åºéä¸å¯è§ã

éè¦è¯´æçæ¯ç®åè¯æ³¨æ²¡æå®å¨æºå¶ï¼ä»»ä½èæ¥å°ææ°æ®åºä¸çç¨æ·é½å¯ä»¥çå°ææ该æ°æ®åºå¯¹è±¡çè¯æ³¨ ï¼å°½ç®¡åªæè¶çº§ç¨æ·å¯ä»¥ä¿®æ¹ä¸å±äºä»ç对象çè¯æ³¨ï¼ãå æ- ¤ï¼ä¸è¦å¨è¯æ³¨éæ¾å®å¨æ§ææå°ä¿¡æ¯ã

EXAMPLES ä¾å

ç»è¡¨mytable å è¯æ³¨ï¼

COMMENT ON TABLE mytable IS ’This is my table.’;

åå é¤å®ï¼

COMMENT ON TABLE mytable IS NULL;

ä¸äºä¾åï¼

COMMENT ON AGGREGATE my_aggregate (double precision) IS ’Computes sample variance’;
COMMENT ON COLUMN my_table.my_column IS ’Employee ID number’;
COMMENT ON DATABASE my_database IS ’Development Database’;
COMMENT ON DOMAIN my_domain IS ’Email Address Domain’;
COMMENT ON FUNCTION my_function (timestamp) IS ’Returns Roman Numeral’;
COMMENT ON INDEX my_index IS ’Enforces uniqueness on employee ID’;
COMMENT ON OPERATOR ˆ (text, text) IS ’Performs intersection of two texts’;
COMMENT ON OPERATOR ˆ (NONE, text) IS ’This is a prefix operator on text’;
COMMENT ON RULE my_rule ON my_table IS ’Logs updates of employee records’;
COMMENT ON SCHEMA my_schema IS ’Departmental data’;
COMMENT ON SEQUENCE my_sequence IS ’Used to generate primary keys’;
COMMENT ON TABLE my_schema.my_table IS ’Employee Information’;
COMMENT ON TRIGGER my_trigger ON my_table IS ’Used for RI’;
COMMENT ON TYPE complex IS ’Complex number data type’;
COMMENT ON VIEW my_view IS ’View of departmental costs’;

COMPATIBILITY å¼å®¹æ§

SQL æ åé没æCOMMENTã

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æå页计åæä¾ã
ä¸æ man æå页计åï¼https://github.com/man-pages-zh/manpages-zh

---