Re: Resize varchar column

Bruno Wolff III said:
> In general (in 7.4.x) you can change data types using add, drop, rename
> and a query to copy/translate the data. This will have the side effect of
> making the updated column the last column when using * to refer to the
> table's columns.

I'll take a look at the system catalogs - thanks for the tip.

> It is possible to change the size of varchar data by updating the system
> catalogs. I don't know the exact details of what to do, but the
> instructions should be in the archives (multiple times).

I was hoping to avoid a column drop and recreate.

Thanks for the info.

John Sidney-Woollett