how do I Add multiple columns using mysql in postgres
 

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

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.