Altering columns order - Mailing list pgsql-general

From Daniele Varrazzo
Subject Altering columns order
Date
Msg-id GKEBLAIAHOIHHOJGAOKJCEMECBAA.piro@officine.it
Whole thread Raw
List 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 by date:

Previous
From: Pedro Miguel Guedes
Date:
Subject: help from Portugal
Next
From: tj
Date:
Subject: duplicates rejected by index reports PGSQL_FATAL_ERROR