Postgres Pro
Downloads
Home   >   mailing lists

Re: changing field length - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: changing field length
Date
Msg-id 000d01c36685$78b2c090$10d4a8c0@mm.eutelsat.org
Whole thread Raw
In response to changing field length  (Jodi Kanter <jkanter@virginia.edu>)
List pgsql-admin
Tree view 
"Jodi Kanter" <jkanter@virginia.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....

pgsql-admin by date:

Previous
From: Jodi Kanter
Date:
Subject: changing field length
Next
From: Stephan Szabo
Date:
Subject: Re: changing field length