Re: How to increase Column width of table

Hello,

 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"

         Please anyone give me the solution for the above.


Thank you.

Regards,
Atul


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx