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

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


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Richard Huxton"
Дата:
Сообщение: Re: photos and OID's
Следующее
От: Larry Rosenman
Дата:
Сообщение: locking/concurrency question.