Re: changing the size of a column without losing data

Hi !

One quick way to do this is to take a dump from your x_db. Edit the dump file
and change your field's defition from character varying(100) to character
varying (50)

Make sure the data is valid for this shorter field. Drop your x_db. Create a
new empty x_db. Read the dump in the new x_db.

BR,

aarni



On Thursday 22 August 2002 08:43 pm, you wrote:
> hi,
>
> How would i change a field which is currently char100 to char50?
>
> have tried:
> ALTER TABLE outlets MODIFY description varchar(50);
>
> but get error:
> parser: parse error at or near "modify"
>
> what is the correct command.
>
> Thx
>
> Mark
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)