How to add multiple columns to a table in Postgres?
Solution 1:
Try this :
ALTER TABLE table ADD COLUMN col1 int, ADD COLUMN col2 int;
Solution 2:
ALTER TABLE IF EXISTS TABLEname
add ADD COLUMN IF NOT EXISTS column_name data_type [column_constraint];
detailed query where column_constraints are optional