Skip site navigation (1) Skip section navigation (2)

Re: changing the size of a varchar column

From: Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il>
To: Scott Marlowe <smarlowe(at)qwest(dot)net>
Cc: Warren Little <wlittle(at)securitylending(dot)com>,pgsql-admin(at)postgresql(dot)org
Subject: Re: changing the size of a varchar column
Date: 2004-09-08 21:34:52
Message-ID: Pine.LNX.4.58.0409090031410.1813@p-roman.jct.ac.il (view raw or flat)
Thread:
Lists: pgsql-admin
Maybe you already know this but the solution is to create a new
table with varchar(200) copy to it the data from the old one.
Then drop the old one and recreate with varchar(200) then copy 
the data back from the tmp table.
Again you probably know all this ,just trying to help...

On Wed, 8 Sep 2004, Scott Marlowe wrote:

> 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.
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 

-- 
Evgeny.

In response to

pgsql-admin by date

Next:From: Simon RiggsDate: 2004-09-08 23:57:47
Subject: Re: When will my database crash?
Previous:From: Tom LaneDate: 2004-09-08 17:39:06
Subject: Re: postgres stopped working

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group