where's ALTER TABLE table DROP [ COLUMN ] column??? - Mailing list pgsql-sql

From bboett@erm1.u-strasbg.fr (Bruno Boettcher)
Subject where's ALTER TABLE table DROP [ COLUMN ] column???
Date
Msg-id 20010524004906.K12080@erm1.u-strasbg.fr
Whole thread Raw
List pgsql-sql
Hello!

just trying to write an upgrade script for my bookkeeping system.... and
noticed that it seems that i can't throw out the legacy stuff
accumulated over time.... 

as far as i can tell, i can add columns to a table, but can't remove
them later on.....


is this true? any easy way to circumvent this inside the DB, without
destroying the existing tables (the problem: make backup f the existing
table, without the offending column, drop the table, recreate it, feed
it with the backup) if someone has any solution for this, i am taker!


-- 
ciao bboett
==============================================================
bboett@earthling.net
http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett
===============================================================
the total amount of intelligence on earth is constant.
human population is growing....


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error msg.
Next
From: Ron Peterson
Date:
Subject: Re: Recursive select