Rename an Index 1ALTER INDEX the_oldtablename_idx01 RENAME TO thenewtablename_idx01 NOTE: This has similar syntax for renaming primary key. The only difference noted is that for primary key, the suffix is always _pkey. In index, it's either idxNN or idexNN (where NN is a nunber, e.g. '01')
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 …