Re: Resize varchar column - Mailing list pgsql-general

From John Sidney-Woollett
Subject Re: Resize varchar column
Date
Msg-id 2805.192.168.0.64.1075910402.squirrel@mercury.wardbrook.com
Whole thread Raw
In response to Re: Resize varchar column  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: Resize varchar column  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Resize varchar column  (Richard Huxton <dev@archonet.com>)
List 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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Anyone has nls activated on Mac OS X?
Next
From: Dirk Försterling
Date:
Subject: Re: Resize varchar column