Update Table Column Comments in Postgresql

Update comments on table columns

1COMMENT ON COLUMN <table_name>.<column_name> IS '<new_comment_here>';

See Stackoverflow reference and Postgres.org reference

NOTE: Comment cannot be altered or dropped.

To remove comment, set it to NULL as follows:

1COMMENT ON COLUMN <table_name>.<column_name> IS NULL;