Re: Help changing varchar field - Mailing list pgsql-general

From Robert Treat
Subject Re: Help changing varchar field
Date
Msg-id 1034865232.18815.5.camel@camel
Whole thread Raw
In response to Help changing varchar field  ("Karl Stubsjoen" <karl@azprogolf.com>)
Responses Re: Help changing varchar field  (Alvaro Herrera Munoz <alvherre@dcc.uchile.cl>)
List pgsql-general
AFAIK there's no easy way to do this. Essentially you'll need to create
a new field of varchar(15), copy the contents of varchar(6), drop
varchar(6), then rename varchar(15). I'd recommend doing it all in one
transaction.

Robert Treat

On Wed, 2002-10-16 at 17:06, Karl Stubsjoen wrote:
> Hello,  I have a varchar field (6).  I need to change it to varchar(15).
> How do I do this from a command line?
>
> Karl




pgsql-general by date:

Previous
From: James Hall
Date:
Subject: Re: Pg_dumpall problem
Next
From: Alvaro Herrera Munoz
Date:
Subject: Re: Help changing varchar field