Re: How to increase Column width of table

>
> 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