pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
where's ALTER TABLE table DROP [ COLUMN ] column???
2+ messages / 2 participants
[nested] [flat]

* where's ALTER TABLE table DROP [ COLUMN ] column???
@ 2001-05-23 22:49 Bruno Boettcher <bboett@erm1.u-strasbg.fr>
  2001-05-25 06:30 ` Re: where's ALTER TABLE table DROP [ COLUMN ] column??? Keith Gray <keith@heart.com.au>
  0 siblings, 1 reply; 2+ messages in thread

From: bboett@erm1.u-strasbg.fr @ 2001-05-23 22:49 UTC (permalink / raw)
  To: 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....



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: where's ALTER TABLE table DROP [ COLUMN ] column???
  2001-05-23 22:49 where's ALTER TABLE table DROP [ COLUMN ] column??? Bruno Boettcher <bboett@erm1.u-strasbg.fr>
@ 2001-05-25 06:30 ` Keith Gray <keith@heart.com.au>
  0 siblings, 0 replies; 2+ messages in thread

From: Keith Gray @ 2001-05-25 06:30 UTC (permalink / raw)
  To: Bruno Boettcher <bboett@erm1.u-strasbg.fr>; pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-05-25 06:30 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-23 22:49 where's ALTER TABLE table DROP [ COLUMN ] column??? Bruno Boettcher <bboett@erm1.u-strasbg.fr>
2001-05-25 06:30 ` Keith Gray <keith@heart.com.au>

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