Re: Re-order columns?

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(at)jakobs(dot)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.
>
> 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 -
>

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>