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@xxxxxxxxxx> 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.
Of you prefer a different order, use a view.Am 29. Juli 2020 22:45:06 MESZ schrieb "David G. Johnston" <david.g.johnston@xxxxxxxxx>:On Wednesday, July 29, 2020, Wells Oliver <wells.oliver@xxxxxxxxx> wrote: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 longThere 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 -
Wells Oliver
wells.oliver@xxxxxxxxx
wells.oliver@xxxxxxxxx
