X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1949A52865 for ; Tue, 28 Jun 2005 11:55:15 -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 44678-07 for ; Tue, 28 Jun 2005 14:55:06 +0000 (GMT) Received: from mopsy2.musc.edu (mopsy2.musc.edu [128.23.34.56]) by svr1.postgresql.org (Postfix) with ESMTP id CDF6A52833 for ; Tue, 28 Jun 2005 11:55:04 -0300 (ADT) Received: from revere3.musc.edu (revere3.musc.edu [128.23.203.9]) by mopsy2.musc.edu (8.12.10/8.12.10) with ESMTP id j5SEdkLn013050; Tue, 28 Jun 2005 10:39:46 -0400 Received: from cottontail.musc.edu (cottontail.musc.edu [128.23.203.163]) by revere3.musc.edu (8.12.9/8.12.9) with ESMTP id j5SEdjhk011249; Tue, 28 Jun 2005 10:39:45 -0400 (EDT) Received: from [128.23.116.246] (grid.135can.musc.edu [128.23.116.246]) (authenticated bits=0) by cottontail.musc.edu (8.12.10/8.12.10) with ESMTP id j5SEdjQm019581 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NOT); Tue, 28 Jun 2005 10:39:45 -0400 Message-ID: <42C1613F.4000605@musc.edu> Date: Tue, 28 Jun 2005 10:39:59 -0400 From: Chuming Chen Reply-To: chen@musc.edu User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050513 Fedora/1.7.8-2 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Peter Eisentraut Cc: pgsql-admin@postgresql.org Subject: Re: change existing table definition References: <42C15044.4030407@musc.edu> <200506281614.25981.peter_e@gmx.net> In-Reply-To: <200506281614.25981.peter_e@gmx.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-MUSC-MailScanner-Information: Please contact postmstr@musc.edu for more information X-MUSC-MailScanner: Found to be clean X-MUSC-MailScanner-SpamCheck: X-MailScanner-From: chen@musc.edu X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/260 X-Sequence-Number: 18015 Peter Eisentraut wrote: >Chuming Chen wrote: > > >>How can I change the column definition of an existing table, ie. from >>varchar(30) to varchar(50)? Is there any way to add a new column to >>an existing table? >> >> > >The ALTER TABLE command can do all that. You need version 8.0 or later >for some functionality though. > > > Is there another way to do it in 7.* ?