How to drop multiple columns in postgresql

Question

I want to drop 200 columns in my table in PostgreSQL. I tried:

ALTER TABLE my_table
DROP COLUMN col1, col2

But I get an error like this:

ERROR: syntax error at or near "col2"

Answer 1

Check this:

ALTER TABLE table DROP COLUMN col1, DROP COLUMN col2;