ALTER TABLE ALTER TABLE bluegroper (TechnicalUser) (OP) 6 Apr 09 18:54 Hey forumThis should be easy but I have PBKAC.Can annybody please help me with correct syntax ?rate is presently varchar(15), need (25).TIA'sCODEALTER TABLE phonecalls ALTER COLUMN rate TYPE varchar(25) RE: ALTER TABLE stefanwagner (Programmer) 7 Apr 09 00:06 I don't see any error. You could omit the keyword "COLUMN" afaik, but it schouldn't be a problem:ALTER TABLE phonecalls ALTER rate TYPE varchar(25);Maybe an export would help, modify the varchar-width, and reimport.Or add a column rate2 (vc25), fill with data from rate, delete rate, rename rate2 to rate? don't visit my homepage: http://home.arcor.de/hirnstrom/minis/index.html RE: ALTER TABLE feherke (Programmer) 7 Apr 09 03:08 HiAre you sure you are using PostgreSQL 8.x ? altering the type was not supported yet in 7.x version.Personally I always do it the "long" way :Quote (stefanwagner):add a column rate2 (vc25), fill with data from rate, delete rate, rename rate2 to rateAn alternative I never recommend but my colleague uses, is to update the pg_attibute system table directly. Feherke.http://rootshell.be/~feherke/ RE: ALTER TABLE bluegroper (TechnicalUser) (OP) 7 Apr 09 07:48 using pg 7.4.19Thx for clues. I shall do it the "long" way.