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