How to add multiple columns in AWS redshift with alter table query

Question

Is it possible to add multiple columns in a single Alter query in Redshift

Alter table employee add column Name, add column Age, add column Salary

Taenia

Answer 1

According to Redshift Documentation, You can add only one column in each ALTER TABLE statement. Only way to add multiple columns is executing multiple ALTER TABLE statements.

Bara

....................🤦 – Naji

This is another in a long list of things that makes me loathe working with AWS. The pain this service causes me, coupled with its ubiquity, is one of the biggest mysteries I've ever encountered. – Sparling

Answer 2

We have to use multiple ALTER TABLE statements.

Biparous

What does this add to the other answer, posted nearly a year ago? – Ghassan