COMMENT#
Synopsis#
COMMENT ON ( TABLE | VIEW | COLUMN ) name IS 'comments'
Description#
Set the comment for a object. The comment can be removed by setting the comment to NULL
.
Examples#
Change the comment for the users
table to be master table
:
COMMENT ON TABLE users IS 'master table';
Change the comment for the users
view to be master view
:
COMMENT ON VIEW users IS 'master view';
Change the comment for the users.name
column to be full name
:
COMMENT ON COLUMN users.name IS 'full name';