Re: How to increase Column width of table - Mailing list pgsql-sql

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