Re: changing field length

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Cc: "Jodi Kanter" <jkanter(at)virginia(dot)edu>
Subject: Re: changing field length
Date: 2003-08-19 19:09:52
Message-ID: 000d01c36685$78b2c090$10d4a8c0@mm.eutelsat.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Jodi Kanter" <jkanter(at)virginia(dot)edu> wrote:
> I am running 7.3.3. Can I change a field that is varying character(128)
> to varying character(250)?

nope.

You can
a) create a new column named tmp of character(250).
b) copy the content from old column to new column
c) drop the old column
d) rename the tmp column to the correct name

Regards
Gaeatano Mendola

PS: Be carefull with the constraint....

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-08-19 19:33:00 Re: changing field length
Previous Message Jodi Kanter 2003-08-19 18:34:24 changing field length