3 ms·
For what it's worth, there is currently some active work in this area [1]. It's too late for 15, but it might land in 16 (next fall). [1]: https://www.postgres
by uhoh-itsmaciek 4y ago
For what it's worth, there is currently some active work in this area [1]. It's too late for 15, but it might land in 16 (next fall).
[1]: https://www.postgresql.org/message-id/flat/20220628083230.c4qhp4fdp3dp22ig%40jrouhaud https://www.postgresql.org/message-id/flat/20220628083230.c4...
- terandle 4y agoNot sure they really need to complicate the system with different physical/logical identifiers. Just an easy way to move physical columns around if you're willing to do a full table lock would be nice.
- mekster 4y agoFinally? I'm about to move off from PostgreSQL back to MySQL primarily for this reason. After a period of development, the ordering becomes a mess by keep adding columns to the end with no logical grouping and it's a pain to view the data that way.