How to rename column in Redshift database

Use the below command to rename column of a Redshift table.

alter table tablename                      
rename column columnname to new_columnname;
See also  How to Revoke super user privileges from a Redshift database user