Is there any way to delete a column

Поиск
Список
Период
Сортировка
От shreedhar
Тема Is there any way to delete a column
Дата
Msg-id 006d01c2e6e5$60285370$1201a8c0@a4005
обсуждение исходный текст
Ответы Re: Is there any way to delete a column
Re: Is there any way to delete a column
Список pgsql-general
To delete a column from table , I am following the method as per postgresl documents.
 
1) creating emptable with same structure and moving all records.
2) creating another table with out column which you have remove.
3) Creating all constraints.
4) moving all data from temp table to new table and removing temp table.
 
Is there any way to delete a column, other than above method
 
Regards,
Sreedhar
 
 

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