| From: | "D(dot) Duccini" <duccini(at)backpack(dot)com> |
|---|---|
| To: | andrea gelmini <bungle(at)linux(dot)it> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: ehm... drop column... |
| Date: | 2000-10-31 07:54:12 |
| Message-ID: | Pine.GSO.4.03.10010310152590.29183-100000@ra.bpsi.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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!"
-----------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Poul L. Christiansen | 2000-10-31 13:34:52 | Re: ehm... drop column... |
| Previous Message | andrea gelmini | 2000-10-31 07:46:54 | ehm... drop column... |