Re: Re-order columns?

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(dot)g(dot)johnston(at)gmail(dot)com>:
>On Wednesday, July 29, 2020, Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
>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 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 -