Re: Help changing varchar field

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Karl Stubsjoen <karl(at)azprogolf(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help changing varchar field
Date: 2002-10-17 14:33:52
Message-ID: 1034865232.18815.5.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera Munoz 2002-10-17 14:45:32 Re: Help changing varchar field
Previous Message Robert Treat 2002-10-17 14:27:56 Re: Fwd: [BUGS] Fwd: FATAL 1: Database dialup does not