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 until I 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 foreign keys referencing to it and eventually 
alter other objects depending onto it?

Thanks a lot

Daniele


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to