Adding multiple column in alter statement?

[Ashish Karalkar <ashish_postgre@xxxxxxxxxxx>]

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...

---

Here?s a new way to find what you're looking for - Yahoo! Answers