Re: Re-order columns?
| От | Holger Jakobs |
|---|---|
| Тема | Re: Re-order columns? |
| Дата | |
| Msg-id | 52AC5CB8-0EBF-4B28-9673-723AC252F619@jakobs.com обсуждение исходный текст |
| Ответ на | Re: Re-order columns? ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: Re-order columns?
Re: Re-order columns? Re: Re-order columns? |
| Список | 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.
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
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.g.johnston@gmail.com>:
On Wednesday, July 29, 2020, Wells Oliver <wells.oliver@gmail.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 longThere 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 -
В списке pgsql-admin по дате отправления: