Обсуждение: Altering columns order

Поиск
Список
Период
Сортировка

Altering columns order

От
"Daniele Varrazzo"
Дата:
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