| From: | "John Sidney-Woollett" <johnsw(at)wardbrook(dot)com> |
|---|---|
| To: | "Bruno Wolff III" <bruno(at)wolff(dot)to> |
| Cc: | "John Sidney-Woollett" <johnsw(at)wardbrook(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Resize varchar column |
| Date: | 2004-02-04 16:00:02 |
| Message-ID: | 2805.192.168.0.64.1075910402.squirrel@mercury.wardbrook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dirk Försterling | 2004-02-04 16:31:43 | Re: Resize varchar column |
| Previous Message | Tom Lane | 2004-02-04 15:52:22 | Re: Anyone has nls activated on Mac OS X? |