How to add multiple columns to a table in Postgres?

Question

How do I add multiple columns in one query statement in PostgreSQL using pgadmin3?

Erkan Haspulat · Accepted Answer · 2011-03-10 14:15:32Z

334

Try this :

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

answered Mar 10, 2011 at 14:15

Erkan Haspulat

12.7k7 gold badges43 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mu is too short Over a year ago

You might want to reference the docs for posterity, ALTER TABLE [ ONLY ] name [ * ] action [, ... ], postgresql.org/docs/current/static/sql-altertable.html

Brian D Over a year ago

and to set the default value: ALTER TABLE table ADD COLUMN col1 int default 0, ADD COLUMN col2 text default 'foo';

RaM PrabU · Accepted Answer · 2019-09-24 13:44:09Z

1

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

detailed query where column_constraints are optional

answered Sep 24, 2019 at 13:44

RaM PrabU

4655 silver badges16 bronze badges

1 Comment

Doug P Over a year ago

Ouch... Neither of the syntaxes above work in Redshift :-( I get errors: ERROR: syntax error at or near "," LINE 1: ALTER TABLE x ADD COLUMN col1 int, ADD COLUMN colX int

Collectives™ on Stack Overflow

How to add multiple columns to a table in Postgres?

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related