Received: from albatross.prod.itd.earthlink.net (albatross.mail.pas.earthlink.net [207.217.120.120]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1IE0rE56010 for ; Mon, 18 Feb 2002 09:00:54 -0500 (EST) (envelope-from nickf@ontko.com) Received: from 1cust39.tnt2.richmond.in.da.uu.net ([63.26.248.39] helo=nick) by albatross.prod.itd.earthlink.net with smtp (Exim 3.33 #1) id 16coLP-0007nY-00; Mon, 18 Feb 2002 06:00:43 -0800 Reply-To: From: "Nick Fankhauser" To: , Subject: Re: Need to change the size of a field Date: Mon, 18 Feb 2002 08:56:14 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 In-Reply-To: Importance: Normal X-Archive-Number: 200202/207 X-Sequence-Number: 6632 I don't think you can alter a column in the current version, but here's an example of a workaround that should do the job: create table change_me (id int, text varchar(20)); [Then I add some data & decide I need to widen the text field without losing the data.] create table temp_change_me as select * from change_me; drop table change_me; create table change_me (id int, text varchar(50)); insert into change_me (id, text) (select id, text from temp_change_me); drop table temp_change_me; hth, Nick > -----Original Message----- > From: pgsql-sql-owner@postgresql.org > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of suresh@mithi.com > Sent: Monday, February 18, 2002 8:31 AM > To: pgsql-sql@postgresql.org > Subject: [SQL] Need to change the size of a field > > > 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 ? > Thanx in advance. > regards > suresh > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >