Re: Re-order columns? - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Re-order columns?
Date
Msg-id CAKFQuwaHDkyVHQdCG-4+nR=jur6=tx=YqGefGxhtrHQjW12kbA@mail.gmail.com
Whole thread Raw
In response to Re: Re-order columns?  (Holger Jakobs <holger@jakobs.com>)
Responses Re: Re-order columns?
List pgsql-admin
On Wednesday, July 29, 2020, Holger Jakobs <holger@jakobs.com> wrote:

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.

Technical reasons are real reasons.  The order of columns is very real, guaranteed (beware of inherits), thing in PostgreSQL whereas there is no guarantee regarding row order outside of a select query order by.  That said I do agree that fulfilling “ocd” drives isn’t a strong use case to work on the feature.

David J.

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: Re-order columns?
Next
From: Olivier Gautherot
Date:
Subject: Re: Re-order columns?