How to Rename a Column in Redshift

Changing a column name in Redshift involves using the ALTER TABLE command:

ALTER TABLE products RENAME COLUMN product_name TO product_full_name;
Cta

Finally, a unified workspace for your SQL development

Get more done, together, with PopSQL and Redshift