How to add multiple columns to a table in Postgres?

postgresql pgadmin
Hick picture Hick · Mar 10, 2011 · Viewed 58.4k times · Source

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

Answer

Erkan Haspulat picture Erkan Haspulat · Mar 10, 2011

Try this :

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

Related questions

Postgresql: password authentication failed for user "postgres"

I have installed PostgreSQL 8.4, Postgres client and Pgadmin 3. Authentication failed for user "postgres" for both console client and Pgadmin. I have typed user as "postgres" and password "postgres", because it worked before. But now authentication is failed. I did it …

Read More
How connect Postgres to localhost server using pgAdmin on Ubuntu?

I installed Postgres with this command sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev Using psql --version on terminal I get psql (PostgreSQL) 9.3.4 then I installed pgadmin with sudo apt-get install pgadmin3 Later I opened the UI and create the server …

Read More
Export and import table dump (.sql) using pgAdmin

I have pgAdmin version 1.16.1 So, for exporting table dumm I do: Right click on table, then in menu click on backup, then in Format choice Plain and save file as some_name.sql Then I remove table. Ok, now I …

Read More