Pgadmin - Order columns

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Order columns

Daniel Seichter

2005-04-07, 7:03 am

Hello,

isn't there a function for reorder columns of an existing table?

Daniel

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Andreas Pflug

2005-04-07, 8:03 pm

Daniel Seichter wrote:
> Hello,
>
> isn't there a function for reorder columns of an existing table?

No, and there never will be, this was discussed exhaustively on
pgsql-hackers.
Simply *never-ever* rely on the order of columns of a SELECT *, on any
database system; it's always a call for trouble.

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere
" to majordomo@postgresql
.org)

Sponsored Links