Create a new column alter <tablename> add column <newcolname> varchar(25);
Then copy the old column into the new column: update <tablename> set <newcolname> = <oldcolname>; Drop the last column: alter <tablename> drop column <oldcolname>; Rename the column: alter <tablename> rename column <newcolname> to <oldcolname>; Take care for INDEXES if there are any. This should do it. Best regards. ----- Original Message ----- From: "Chitta Ranjan Mishra" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
