ALTER TABLE

[bluegroper]

Hey forum
This should be easy but I have PBKAC.
Can annybody please help me with correct syntax ?
rate is presently varchar(15), need (25).
TIA's

ALTER TABLE phonecalls ALTER COLUMN rate TYPE varchar(25)

 

[stefanwagner]

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

 

[feherke]

Hi

Are you sure you are using PostgreSQL 8.x ? [tt]alter[/tt]ing the [tt]type[/tt] was not supported yet in 7.x version.

Personally I always do it the "long" way :

add a column rate2 (vc25), fill with data from rate, delete rate, rename rate2 to rate

An alternative I never recommend but my colleague uses, is to [tt]update[/tt] the [tt]pg_attibute[/tt] system table directly.

Feherke.

http://rootshell.be/~feherke/

 

[bluegroper]

using pg 7.4.19
Thx for clues. I shall do it the "long" way.