Re: changing the size of a varchar column

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "Warren Little" <wlittle(at)securitylending(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: changing the size of a varchar column
Date: 2004-09-08 17:22:08
Message-ID: 1094664128.13944.16.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2004-09-08 17:22:35 Re: postgres stopped working
Previous Message Josh Berkus 2004-09-08 17:05:00 Re: [SQL] How to rename a constraint/trigger??