Postgres Pro
Downloads
Home   >   mailing lists

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

From Atul Pedgaonkar
Subject Re: How to increase Column width of table
Date
Msg-id OFENLAOAANCDIEKFLGOIIEKCCAAA.atul@imcindia.net
Whole thread Raw
List pgsql-sql
Tree view 
Hello,
Atul here, i have one table and i would like to increase the length ofexisting 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

pgsql-sql by date:

Previous
From: Mike Meyer
Date:
Subject: Re: Rule for updating through a view.
Next
From: Christoph Haller
Date:
Subject: Re: How to increase Column width of table