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....
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
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