Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4SCZ6A95414 for ; Mon, 28 May 2001 08:35:06 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4Q7vtA46659 for ; Sat, 26 May 2001 03:57:55 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f4Q7iNE71900 for pgsql-sql@postgresql.org; Sat, 26 May 2001 03:44:23 -0400 (EDT) (envelope-from news) From: "Madness" X-Newsgroups: comp.databases.postgresql.sql Subject: Ynt: where's ALTER TABLE table DROP [ COLUMN ] column??? Date: Sat, 26 May 2001 10:49:05 +0300 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 41 Message-ID: <9enmsl$266o$1@news.tht.net> References: <3B0DFBF9.CEBDC3CC@heart.com.au> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 To: pgsql-sql@postgresql.org X-Archive-Number: 200105/295 X-Sequence-Number: 3124 Hi, I want to make a little correction. The correct syntax should be: SELECT [all columns except named] into mytemp1 from [$table_name] ; drop table [$table_name]; SELECT * into [$table_name] from mytemp1; With regards, Devrim GÜNDÜZ Keith Gray wrote in message news:3B0DFBF9.CEBDC3CC@heart.com.au... > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html