Re: Need to change the size of a field - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Need to change the size of a field
Date
Msg-id 20020218102327.X75404-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Need to change the size of a field  (<suresh@mithi.com>)
List pgsql-sql
On Mon, 18 Feb 2002 suresh@mithi.com wrote:

> Hi
>
> I have a table with one of the fields as a varchar(32) field. This table has
> about 100,000 records.
> I want to increase the size of the varchar field to 64. How can this be done
> without affecting the data already present  ?

Dump and restore after changing the field length is usually easiest, but
if you don't mind a little hacking in the system tables, check out the
archives and you'll find the particular recipe for doing it.



pgsql-sql by date:

Previous
From: Shane Wright
Date:
Subject: Re: table locking
Next
From: "RPI"
Date:
Subject: help importing external excel file