Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1IIOqE68378 for ; Mon, 18 Feb 2002 13:24:56 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 6AFD9D5E5; Mon, 18 Feb 2002 10:24:16 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 5CAEA5BF9; Mon, 18 Feb 2002 10:24:16 -0800 (PST) Date: Mon, 18 Feb 2002 10:24:16 -0800 (PST) From: Stephan Szabo To: Cc: Subject: Re: Need to change the size of a field In-Reply-To: Message-ID: <20020218102327.X75404-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200202/218 X-Sequence-Number: 6642 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.