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

Поиск
Список
Период
Сортировка
От bboett@erm1.u-strasbg.fr (Bruno Boettcher)
Тема where's ALTER TABLE table DROP [ COLUMN ] column???
Дата
Msg-id 20010524004906.K12080@erm1.u-strasbg.fr
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error msg.
Следующее
От: Ron Peterson
Дата:
Сообщение: Re: Recursive select