Vertica Analytics Platform Version 9.2.x Documentation

COMMENT ON NODE

Adds, revises, or removes a comment on a node. Each object can have one comment. Comments are stored in the system table COMMENTS.

Dropping an object drops all comments associated with the object.

Syntax

COMMENT ON NODE node‑name IS  { 'comment' | NULL }

Parameters

node‑name

The name of the node associated with the comment.

comment

Specifies the comment text to add. If a comment already exists for this node, this comment overwrites the previous one.

Comments can be up to 8192 characters in length. If a comment exceeds that limitation, Vertica truncates the comment and alerts the user with a message.

Enclose a blank value within single quotes to remove an existing comment.

NULL

Removes an existing comment.

Privileges

Superuser or object owner

Examples

The following example adds a comment for the initiator node:

=> COMMENT ON NODE initiator IS 'Initiator node';

The following examples removes a comment from the initiator node.

=> COMMENT ON NODE initiator IS NULL;
=> COMMENT ON NODE initiator IS '';

See Also

COMMENTS