How to Add Multiple Columns to a Table in Postgres?
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...
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 int;
ALTER TABLE IF EXISTS TABLEname
add ADD COLUMN IF NOT EXISTS column_name data_type [column_constraint];
detailed query where column_constraints are optional
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
