Thread: where's ALTER TABLE table DROP [ COLUMN ] column???

where's ALTER TABLE table DROP [ COLUMN ] column???

From
bboett@erm1.u-strasbg.fr (Bruno Boettcher)
Date:
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....


Re: where's ALTER TABLE table DROP [ COLUMN ] column???

From
Keith Gray
Date:
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


Ynt: where's ALTER TABLE table DROP [ COLUMN ] column???

From
"Madness"
Date:
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