Altering columns order

Поиск
Список
Период
Сортировка
От Daniele Varrazzo
Тема Altering columns order
Дата
Msg-id GKEBLAIAHOIHHOJGAOKJCEMECBAA.piro@officine.it
обсуждение исходный текст
Список pgsql-general
Hi everybody.

Is there any way to alter the order the columns appear in a table (apart from using views)?

I tried changing attnum from pg_attribute... but I could only mess the server up! Successive INSERT command crashed it
untilI restored the previous order... :-\ 

If the answer was "You have to create a new table and dump everything into it": is there a simple way to move also the
foreignkeys referencing to it and eventually alter other objects depending onto it? 

Thanks a lot

Daniele


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

Предыдущее
От: Pedro Miguel Guedes
Дата:
Сообщение: help from Portugal
Следующее
От: tj
Дата:
Сообщение: duplicates rejected by index reports PGSQL_FATAL_ERROR