COMMENT

Synopsis

text

COMMENT ON ( TABLE | VIEW | COLUMN ) name IS 'comments'

Set the comment for an object. The comment can be removed by setting the comment to NULL.

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