Help---- Urgent
Help---- Urgent
От:
Chitta Ranjan Mishra <c_r_mishra@yahoo.co.in>
Дата:
Dear Sir,
I wnat to alter the size of one of the column of a
table. How to do this in Postgres ? Plz help me.
It's very urgent...
I tried with the following syntax :
but it failed....
alter table tablename modify(coumnname varchar(25));
it's very urgnet...plz reply soon..
Thanking you,
Regds
C.R.Mishra
________________________________________________________________________
Yahoo! India Mobile: Download the latest polyphonic ringtones.
Go to http://in.mobile.yahoo.com
Re: Help---- Urgent
От:
"Andrei Bintintan" <klodoma@ar-sd.net>
Дата:
Create a new column alter add column varchar(25); Then copy the old column into the new column: update set = ; Drop the last column: alter drop column ; Rename the column: alter rename column to ; Take care for INDEXES if there are any. This should do it. Best regards. ----- Original Message ----- From: "Chitta Ranjan Mishra" To: Sent: Thursday, December 11, 2003 7:19 AM Subject: [ADMIN] Help---- Urgent > Dear Sir, > I wnat to alter the size of one of the column of a > table. How to do this in Postgres ? Plz help me. > It's very urgent... > > I tried with the following syntax : > but it failed.... > > alter table tablename modify(coumnname varchar(25)); > > it's very urgnet...plz reply soon.. > > Thanking you, > Regds > C.R.Mishra > > > > > ________________________________________________________________________ > Yahoo! India Mobile: Download the latest polyphonic ringtones. > Go to http://in.mobile.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Re: Help---- Urgent
От:
"Contact" <contact@ar-sd.net>
Дата:
Create a new column alter add column varchar(25); Then copy the old column into the new column: update set = ; Drop the last column: alter drop column ; Rename the column: alter rename column to ; Take care for INDEXES if there are any. This should do it. Best regards. ----- Original Message ----- From: "Chitta Ranjan Mishra" To: Sent: Thursday, December 11, 2003 7:19 AM Subject: [ADMIN] Help---- Urgent > Dear Sir, > I wnat to alter the size of one of the column of a > table. How to do this in Postgres ? Plz help me. > It's very urgent... > > I tried with the following syntax : > but it failed.... > > alter table tablename modify(coumnname varchar(25)); > > it's very urgnet...plz reply soon.. > > Thanking you, > Regds > C.R.Mishra > > > > > ________________________________________________________________________ > Yahoo! India Mobile: Download the latest polyphonic ringtones. > Go to http://in.mobile.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org