From: Madness <devrim@oper.metu.edu.tr>
To: pgsql-sql@postgresql.org
Subject: Ynt: where's ALTER TABLE table DROP [ COLUMN ] column???
Date: Sat, 26 May 2001 10:49:05 +0300
Message-ID: <9enmsl$266o$1@news.tht.net> (raw)
References: <3B0DFBF9.CEBDC3CC@heart.com.au>
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 <keith@heart.com.au> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: devrim@oper.metu.edu.tr
Subject: Re: Ynt: where's ALTER TABLE table DROP [ COLUMN ] column???
In-Reply-To: <9enmsl$266o$1@news.tht.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox