Received: from chac.qld.edu.au (linux.chac.qld.edu.au [203.37.221.131] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id SAA11420 for ; Thu, 30 Mar 2000 18:06:45 -0500 (EST) (envelope-from jhunt@chac.qld.edu.au) Received: from chac.qld.edu.au (chac.inet [203.37.221.129]) by chac.qld.edu.au (8.9.3/8.9.3) with ESMTP id IAA32639; Fri, 31 Mar 2000 08:58:55 +1000 (EST) (envelope-from jhunt@chac.qld.edu.au) Message-ID: <38E3DE10.40B44D60@chac.qld.edu.au> Date: Fri, 31 Mar 2000 09:06:56 +1000 From: Julie Hunt Reply-To: jhunt@chac.qld.edu.au Organization: Cannon Hill Anglican College X-Mailer: Mozilla 4.61 (Macintosh; I; PPC) X-Accept-Language: en MIME-Version: 1.0 To: Aguinaldo Fagundes Junior CC: pgsql-sql@postgresql.org Subject: Re: removing a field from a table References: <35DE6A7B82C8D3119B3B00508B8B7A492BB98C@PAENTMS1> Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F5353" Content-Transfer-Encoding: 7bit X-Archive-Number: 200003/7 Read the section on alter table under compatibility:- http://www.postgresql.org/docs/user/sql-altertable.htm Aguinaldo Fagundes Junior wrote: > Another question about fields... > > To add a new field I can use "altertable", but to remove one without droping > the table and creating it again, how can I procede?? > > Thank you.