Panorama Média Global

Name: How to Add Multiple Columns to a Table in Postgres?
Uploaded: 2026-10-06T04:42:05+00:00
Duration: 19 min 26 s
Description: How Do I Add Multiple Columns in One Query Statement in Postgresql Using Pgadmin3? 2 Answers Try This: Alter Table Table Add Column Col1 Int, Add Column Col2...

Question

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

Accepted Answer

Try this :

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

Answer 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

Panorama Média Global

How to Add Multiple Columns to a Table in Postgres?

2 Answers

Your Answer

Alexander Ross

2 Answers

Your Answer

Sign up or log in

Post as a guest

Alexander Ross