Skip to main content

COMMENT

Synopsis​

COMMENT ON ( TABLE | 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.name column to be full name:

COMMENT ON COLUMN users.name IS 'full name';