How to add multiple columns to a table in Postgres?

postgresql pgadmin

Try this :

ALTER TABLE table ADD COLUMN col1 int, ADD COLUMN col2 int;

postgresql pgadmin

ALTER TABLE  IF EXISTS  TABLEname add ADD  COLUMN   IF NOT EXISTS  column_name data_type  [column_constraint];

detailed query where column_constraints are optional

CodeHunter