Adding multiple column in alter statement? - Mailing list pgsql-general

Hello All,

I want to add multiple  column to a table using single alter statemet,

someting like this:

 

alter table admin_session  add column accounting_session varchar(1) not null default '0',accounting_active varchar(1),acc_start_date date,acc_end_date date;

 

is there any way?

 

Thanks in Advance

 

With Regards

Ashish...