Adding multiple column in alter statement?

From: Ashish Karalkar <ashish_postgre(at)yahoo(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Adding multiple column in alter statement?
Date: 2007-04-05 05:58:01
Message-ID: 633163.90235.qm@web94302.mail.in2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-04-05 06:09:09 Re: Adding multiple column in alter statement?
Previous Message Sergei Shelukhin 2007-04-05 05:56:46 Re: a couple of newbie question - deferrable, varchar vs text, 2 dbs