COMMENT — Define or change the comment of an object.
COMMENT stores a comment about a database object. To modify a comment, issue a new
COMMENT command for the same object. Only one comment string is stored for each object. To remove a comment, specify an empty string (two consecutive single quotes with no intervening space) for
text. Comments are dropped when the object is dropped.
The name of the table (optionally schema-qualified) to comment.
The name of a column (optionally schema-qualified) in
table_name to comment.
The new comment.
There is currently no security mechanism for comments. Any user connected to a database can see all the comments for objects in that database, although only superusers can change comments for objects that they don’t own. Don't put security-critical information in a comment.
Attach a comment to the table
Attach a comment to the
empno column of the
Remove these comments: