How to resize a column in Redshift database

Use the below command to modify the column width in Redshift.

ALTER TABLE table_name ALTER COLUMN column_name TYPE new_data_type;

Example, below command resizes column1 to varchar(100).

ALTER TABLE table_name ALTER COLUMN column1 TYPE varchar(100);

See also  How to drop a materialized view in Redshift database