Received: from localhost.localdomain ([203.199.150.34]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1IDeWE43632 for ; Mon, 18 Feb 2002 08:40:32 -0500 (EST) (envelope-from suresh@mithi.com) Received: from mithi.com (mithi [127.0.0.1]) by localhost.localdomain (8.11.2/8.11.2) with SMTP id g1IDj1x25527 for ; Mon, 18 Feb 2002 19:15:04 +0530 Received: (qmail 25524 invoked by uid 0); 18 Feb 2002 13:45:01 -0000 Received: from unknown (HELO suresh) (192.168.0.100) by 192.168.0.124 with SMTP; 18 Feb 2002 13:45:01 -0000 From: To: Subject: Need to change the size of a field Date: Mon, 18 Feb 2002 19:00:49 +0530 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.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200202/206 X-Sequence-Number: 6631 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