Adds a comment to an object within the database.
COMMENT ON [ [ DATABASE | INDEX | RULE | SEQUENCE | TABLE | TYPE | VIEW ] object_name | COLUMN table_name.column_name | FUNCTION func_name ( argument [, ...] ) | AGGREGATE aggr_func aggr_type | OPERATOR operator ( left_type , right_type ) | TRIGGER trigger_name ON table_name ] IS 'text'
DATABASE | INDEX | RULE | SEQUENCE | TABLE | TYPE | VIEW
The type of database object that you are adding a comment to.
The name of the object (
view) to which you are adding a comment.
The complete column name (within the table
table_name) you are adding a comment to.
[, ...] )
The name of the function on which you are commenting, specified also by the
argumentdata types that it accepts.
The aggregate function name (and associated data type
aggr_type, which it accepts) to which you are adding a comment.
operator ( left_type, right_type )
The name of the operator on which you are commenting (
operator), further described by the data type it operates on to the left, and the data type it operates on to the right, separated by a comma, enclosed within parentheses. If either side is inapplicable, the
NONEkeyword may be used.
trigger_name ON table_name
The name of the trigger on which you are placing a comment, and the name of the table upon which the trigger is placed.
The actual ...