Date: Wed, 29 Jul 2020 22:50:37 +0200
User-Agent: K-9 Mail for Android
In-Reply-To: 
 <CAKFQuwYQbDVoKMT=Eem92F0xitXNgM_iCDMtzjChyT3pAi9N5w@mail.gmail.com>
References: 
 <CAOC+FBUm=b0a2j0h=qDSCqVwO8yWm2fgYSwH2=StVsia4eYLMQ@mail.gmail.com>
 <CAKFQuwYQbDVoKMT=Eem92F0xitXNgM_iCDMtzjChyT3pAi9N5w@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="----PMD6CG1W9WVON3EXT8UT4UYXWTIGMG"
Content-Transfer-Encoding: 7bit
Subject: Re: Re-order columns?
To: pgsql-admin@lists.postgresql.org,"David G. Johnston"
 <david.g.johnston@gmail.com>,Wells Oliver <wells.oliver@gmail.com>
CC: pgsql-admin <pgsql-admin@postgresql.org>
From: Holger Jakobs <holger@jakobs.com>
Message-ID: <52AC5CB8-0EBF-4B28-9673-723AC252F619@jakobs.com>
Precedence: bulk

------PMD6CG1W9WVON3EXT8UT4UYXWTIGMG
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable

Actually, the order of columns is of _no_ importance, since columns are ide=
ntified by name and not by column number=2E It's the same as the order of r=
ows in a table - undefined (unless you use order by)=2E

That columns appear to have some kind of order and show in tools with a st=
able order has technical reasons and is not rooted in relational theory=2E

Of you prefer a different order, use a view=2E


Am 29=2E Juli 2020 22:45:06 MESZ schrieb "David G=2E Johnston" <david=2Eg=
=2Ejohnston@gmail=2Ecom>:
>On Wednesday, July 29, 2020, Wells Oliver <wells=2Eoliver@gmail=2Ecom>
>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=2E  Every so often this gets looked at but has yet to result
>in
>a commit=2E
>
>David J=2E

--=20
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -

------PMD6CG1W9WVON3EXT8UT4UYXWTIGMG
Content-Type: text/html;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body>Actually, the order of columns is of _no_ importan=
ce, since columns are identified by name and not by column number=2E It's t=
he same as the order of rows in a table - undefined (unless you use order b=
y)=2E<br><br>That columns appear to have some kind of order and show in too=
ls with a stable order has technical reasons and is not rooted in relationa=
l theory=2E<br><br>Of you prefer a different order, use a view=2E<br><br><b=
r><div class=3D"gmail_quote">Am 29=2E Juli 2020 22:45:06 MESZ schrieb "Davi=
d G=2E Johnston" &lt;david=2Eg=2Ejohnston@gmail=2Ecom&gt;:<blockquote class=
=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0=2E8ex; border-left: 1px sol=
id rgb(204, 204, 204); padding-left: 1ex;">
On Wednesday, July 29, 2020, Wells Oliver &lt;<a href=3D"mailto:wells=2Eol=
iver@gmail=2Ecom">wells=2Eoliver@gmail=2Ecom</a>&gt; wrote:<br><blockquote =
class=3D"gmail_quote" style=3D"margin:0 0 0 =2E8ex;border-left:1px #ccc sol=
id;padding-left:1ex"><div dir=3D"ltr">I know this kind of dumb, but is ther=
e a way to re-order columns? You know, you have your awesome table all defi=
ned, your favorite modified_at column at the end where you like it, then so=
me 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-po=
pulating the table takes way too long<div><div dir=3D"ltr" data-smartmail=
=3D"gmail_signature"><div dir=3D"ltr"><div></div></div></div></div></div></=
blockquote><div><br></div><div>There is not=2E&nbsp; Every so often this ge=
ts looked at but has yet to result in a commit=2E</div><div><br></div><div>=
David J=2E&nbsp;</div><div><br></div>
</blockquote></div><br>-- <br>Holger Jakobs, Bergisch Gladbach<br>+49 178 =
9759012<br>- sent from mobile, therefore short -<br></body></html>
------PMD6CG1W9WVON3EXT8UT4UYXWTIGMG--