Postgres Pro
Downloads
Home   >   mailing lists

Re: changing the size of a varchar column - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: changing the size of a varchar column
Date
Msg-id 1094664128.13944.16.camel@localhost.localdomain
Whole thread Raw
In response to changing the size of a varchar column  (Warren Little <wlittle@securitylending.com>)
Responses Re: changing the size of a varchar column  (Tsirkin Evgeny <tsurkin@mail.jct.ac.il>)
List pgsql-admin
Tree view 
On Wed, 2004-09-08 at 10:45, Warren Little wrote:
> Hello,
> Does pg7.4.x support resizing a varchar column
> ie varchar(30) -> varchar(200)

No, but some folks have done it by hacking the catalogs.  not
recommended, make a backup, etc...

> If not does the feature in 8.0 relating to changing column types
> support this?

Yes.

pgsql-admin by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [SQL] How to rename a constraint/trigger??
Next
From: "Scott Marlowe"
Date:
Subject: Re: postgres stopped working