| From: | "Daniele Varrazzo" <piro(at)officine(dot)it> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Altering columns order |
| Date: | 2003-10-30 12:36:04 |
| Message-ID: | GKEBLAIAHOIHHOJGAOKJCEMECBAA.piro@officine.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tino Wildenhain | 2003-10-30 13:01:01 | Re: pgAdmin vs SQL Server Enterprise Manager |
| Previous Message | Shridhar Daithankar | 2003-10-30 10:41:26 | Re: slow query performance |