The order of columns is important! I can't go to sleep at night knowing my modified_at isn't at the end of the table! This is serious business.
On Wed, Jul 29, 2020 at 1:50 PM Holger Jakobs <holger@jakobs.com> wrote:
Actually, the order of columns is of _no_ importance, since columns are identified by name and not by column number. It's the same as the order of rows in a table - undefined (unless you use order by).
That columns appear to have some kind of order and show in tools with a stable order has technical reasons and is not rooted in relational theory.
I know this kind of dumb, but is there a way to re-order columns? You know, you have your awesome table all defined, your favorite modified_at column at the end where you like it, then some guy comes along and is like "oh let's add X Y and Z" and your OCD really really really wants the modified_at col at the end, and blowing away/re-populating the table takes way too long
There is not. Every so often this gets looked at but has yet to result in a commit.
David J.
-- Holger Jakobs, Bergisch Gladbach +49 178 9759012 - sent from mobile, therefore short -