Re: changing field length - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: changing field length
Date
Msg-id 20030819122924.O72868-100000@megazone.bigpanda.com
Whole thread Raw
In response to changing field length  (Jodi Kanter <jkanter@virginia.edu>)
List pgsql-admin
On Tue, 19 Aug 2003, Jodi Kanter wrote:

> I am running 7.3.3. Can I change a field that is varying character(128)
> to varying character(250)?

You can either add a column, copy the data across and drop the old column
and use rename to give the new column the old name or if you're willing
to hack at system tables, you can change atttypmod in pg_attribute for the
column from 132 (maxsize + 4 to hold the real size) to 254.


pgsql-admin by date:

Previous
From: "Gaetano Mendola"
Date:
Subject: Re: changing field length
Next
From: "Nick Fankhauser"
Date:
Subject: Re: changing field length