pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedwhere'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>
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-25 06:30 Keith Gray <keith@heart.com.au>
parent: Bruno Boettcher <bboett@erm1.u-strasbg.fr>
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