Skip to content

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';