Received: from gw.heart.com.au (mail.hcs.com.au [203.12.235.237]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4P6R4A04522 for ; Fri, 25 May 2001 02:27:04 -0400 (EDT) (envelope-from keith@heart.com.au) Received: from tardis.heart.com.au (IDENT:root@tardis.heart.com.au [192.168.0.42]) by gw.heart.com.au (8.9.3/8.9.3) with ESMTP id QAA31247; Fri, 25 May 2001 16:57:48 +1000 Received: from heart.com.au ([192.168.0.65]) by tardis.heart.com.au (8.9.3/8.8.7) with ESMTP id QAA21073; Fri, 25 May 2001 16:26:58 +1000 Message-ID: <3B0DFBF9.CEBDC3CC@heart.com.au> Date: Fri, 25 May 2001 16:30:17 +1000 From: Keith Gray X-Mailer: Mozilla 4.74 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: Bruno Boettcher , PostgreSQL Subject: Re: where's ALTER TABLE table DROP [ COLUMN ] column??? References: <20010524004906.K12080@erm1.u-strasbg.fr> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200105/268 X-Sequence-Number: 3096 Bruno Boettcher wrote: > > Hello! > > as far as i can tell, i can add columns to a table, but can't remove > them later on..... > > is this true? My thought would be that somebody must have written an automated version of select [all columns except named] from [named table] into droptemp; drop [named table]; select * from droptemp into [named table]; Would this be available or easily written as a "rule" ?? Could anyone familiar with the code comment? -- Keith Gray