Thread: Changing size of varchar field

I recently saw on this list a way to change the length of a varchar
field using the pg_atttypemod table. My question is: is this safe on a
database with data? Are there any drawbacks to doing this and is there
any plan to make this a standard usable feature?

Thanks

* cg (chris.gamble@cpbinc.com) wrote:
> I recently saw on this list a way to change the length of a varchar
> field using the pg_atttypemod table. My question is: is this safe on a
> database with data? Are there any drawbacks to doing this and is there
> any plan to make this a standard usable feature?
>

i think with any modification you should always pg_dump the database.  if
all hell breaks lose you can always go back to the point you were at
before the change.

dan