From: | Holger Jakobs <holger(at)jakobs(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org,"David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>,Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Re-order columns? |
Date: | 2020-07-29 20:50:37 |
Message-ID: | 52AC5CB8-0EBF-4B28-9673-723AC252F619@jakobs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 -
From | Date | Subject | |
---|---|---|---|
Next Message | Wells Oliver | 2020-07-29 20:52:57 | Re: Re-order columns? |
Previous Message | David G. Johnston | 2020-07-29 20:45:06 | Re: Re-order columns? |