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