X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D97C15E46F9 for ; Wed, 1 Sep 2004 05:45:41 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 64552-06 for ; Wed, 1 Sep 2004 08:45:32 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr1.postgresql.org (Postfix) with ESMTP id 065E75E46CE for ; Wed, 1 Sep 2004 05:45:31 -0300 (ADT) Received: from wp2000 ([157.157.178.195] [157.157.178.195]) by quasar.skima.is; Wed, 1 Sep 2004 08:45:28 Z Message-Id: <00ed01c49000$57ffd400$0100000a@wp2000> From: "gnari" To: "Michael Ryan S. Puncia" , References: <200409010641.i816fDkJ025384@mail.census.gov.ph> Subject: Re: Changing the column length Date: Wed, 1 Sep 2004 08:47:38 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/4 X-Sequence-Number: 8132 From: "Michael Ryan S. Puncia" > I am sorry that my question is out of line with this > group(performance) but I need -general might be more appropriate > > an urgent help :-( .pls .. I need to know how to change the length of the > column. add a new column, use update to copy values from old column, use alter table to rename columns gnari