Skip site navigation (1) Skip section navigation (2)

Re: ehm... drop column...

From: "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>
To: "D(dot) Duccini" <duccini(at)backpack(dot)com>
Cc: andrea gelmini <bungle(at)linux(dot)it>, pgsql-novice(at)postgresql(dot)org
Subject: Re: ehm... drop column...
Date: 2000-10-31 13:34:52
Message-ID: 39FECA7C.48932664@cs.auc.dk (view raw or flat)
Thread:
Lists: pgsql-novice
3. Wait to january (hopefully not longer) when version 7.1 will have the
new "DROP COLUMN" command.

"D. Duccini" wrote:
> 
> its not really possible
> 
> best bet is to
> 
> 1. rename the column to something
> 
>    oldcolumn
> 
> optionally
> 
> 2. create a new table, and select into this new "clean" table, and the
> drop the old one
> 
> On Tue, 31 Oct 2000, andrea gelmini wrote:
> 
> > hi all,
> >       i'm going mad trying to find a way to delete a column
> >       in a table.
> >       if i try it like in oracle, with alter, it doesn't
> >       work, and i didn't find anything in the docs...
> >       so, i'm afraid it's not possibile...
> >
> > thanks for your time,
> > andrea
> >
> 
> -----------------------------------------------------------------------------
> david(at)backpack(dot)com            BackPack Software, Inc.        www.backpack.com
> +1 651.645.7550 voice       "Life is an Adventure.
> +1 651.645.9798 fax            Don't forget your BackPack!"
> -----------------------------------------------------------------------------

In response to

pgsql-novice by date

Next:From: Thomas GoodDate: 2000-10-31 16:28:03
Subject: Re: changing datestyle
Previous:From: D. DucciniDate: 2000-10-31 07:54:12
Subject: Re: ehm... drop column...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group