http://fts.postgresql.org/db/mw/msg.html?mid=1071582
On Tue, 2003-03-25 at 10:18, Christoph Haller wrote: > > > > Atul here, i have one table and i would like to increase the length > of > > existing column and the sql statement is > > > > Exisiting Column is "vehicle_make" varchar(30) > > > > SQL: alter table commute_profile alter column "vehicle_make" > > varchar(100) > > > > But this gives error. > > > > ERROR: parser: parse error at or near "varchar" > > > I'm afraid there is no one-step-solution to this. > You'll have to go the hard way as > > CREATE new_table ( > ... > ... varchar(100), > ... > ); > INSERT INTO new_table as SELECT * FROM old_table; > DROP old_table; > ALTER TABLE new_table RENAME TO old_table; > And don't forget about re-creating related indexes etc. > > Regards, Christoph ---------------------------(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
