how do I Add multiple columns mysql in postgres

Bheki · 01-28-2002, 05:52 AM

Hi

Would u please advice me on how to add multiple columns using mysql in postgres. I have tried the Sql statement : Alter table add (x1 datatype1,x2 datatype2,x3 datatype3)

It is not working. But works if adding one column.

please help

Broomaster1 · 08-28-2003, 03:30 PM

This is good for all sql distro's use add column for every column you want to add. ie.

alter table a add column d int, add column e varchar(30);

this will work.