pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





Message-ID: <9enmsl$266o$1@news.tht.net>
Permalink:  ../9enmsl$266o$1@news.tht.net/
Also on:    postgresql.org/message-id/9enmsl$266o$1@news.tht.net

 · 

reply

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