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