How to drop multiple columns in postgresql Check this: ALTER TABLE table DROP COLUMN col1, DROP COLUMN col2;