On Mon, Jul 10, 2006 at 04:55:40PM -0500, KyLiE wrote: > Hi all, I have a new question, know i'm trying to alter one of my > tables,but the thing is, that I need to change the range of one of my > columns, I've allready try this: > > ALTER TABLE lugar alter column sitio varchar2(500); > > but it gives me a syntax error. and i don't know why. What's the exact error message and what version of PostgreSQL are you running? At least three things could be contributing to the error: 1. The syntax for altering a column's type is ALTER [ COLUMN ] column TYPE type [ USING expression ] The command you showed is missing the word "TYPE". 2. Altering a column's type is supported only in PostgreSQL 8.0 and later; if you're using 7.4 or earlier then you'll need to perform the steps shown in the FAQ: http://www.postgresql.org/docs/faqs.FAQ.html#item4.3 3. PostgreSQL doesn't have a builtin varchar2 type. Unless you've added varchar2 then use varchar instead. Try this: ALTER TABLE lugar ALTER COLUMN sitio TYPE varchar(500); -- Michael Fuhr
