Search code examples
postgresqlpgadmin

How to add multiple columns to a table in Postgres?


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


Solution

  • Try this :

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