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 5CB7E52952 for ; Tue, 28 Jun 2005 10:31:10 -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 29805-05 for ; Tue, 28 Jun 2005 13:31:01 +0000 (GMT) Received: from mopsy2.musc.edu (mopsy2.musc.edu [128.23.34.56]) by svr1.postgresql.org (Postfix) with ESMTP id 3C31352943 for ; Tue, 28 Jun 2005 10:30:59 -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 j5SDRILn020510 for ; Tue, 28 Jun 2005 09:27:18 -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 j5SDRHhk024538 for ; Tue, 28 Jun 2005 09:27:17 -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 j5SDRHQm010253 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NOT) for ; Tue, 28 Jun 2005 09:27:17 -0400 Message-ID: <42C15044.4030407@musc.edu> Date: Tue, 28 Jun 2005 09:27:32 -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: pgsql-admin@postgresql.org Subject: change existing table definition 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/257 X-Sequence-Number: 18012 Hi, all, 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? Thank you for your suggestions. Chuming Chen