Features I'd Like in PostgreSQL

Re:Features I'd Like in PostgreSQL by ceeam on Saturday January 28, 2023 @04:22PM (#34562044)

Reordering columns.

[ Parent | on HN ]

Re:Features I'd Like in PostgreSQL by muhehe on Saturday January 28, 2023 @05:52PM (#34562856)

I dont know. I mean...I'd like that too, but is this really more important than other mentioned features (in this thread or article)? What your reason? (I'm just curious)

[ Parent | on HN ]

Re:Features I'd Like in PostgreSQL by sa46 on Saturday January 28, 2023 @11:05PM (#34564784)

Helps reduce storage space by better aligning columns to reduce padding.

https://www.2ndquadrant.com/en/blog/on-rocks-and-sand/

[ Parent | on HN ]

Re:Features I'd Like in PostgreSQL by mekster on Saturday January 28, 2023 @11:10PM (#34564821)

Not sure why people can live with columns that are added later in a very random order from a logically sorted order with dozens of columns when inspecting data.

I've used PostgreSQL on a live system but switching back to MySQL on next project because I don't miss anything from PostgreSQL but I do miss this basic feature.

I've read somewhere this feature may be coming but I'd just switch back today.

[ Parent | on HN ]

Re:Features I'd Like in PostgreSQL by sroussey on Saturday January 28, 2023 @06:26PM (#34563076)

Create a view?

[ Parent | on HN ]

Re:Features I'd Like in PostgreSQL by barryp on Monday January 30, 2023 @05:36PM (#34587532)

That'd be tedious and error-prone if had schemas with maybe dozens of tables. Now you've also got dozens of views to manage and keep in sync with the underlying tables.

I work with both MySQL and PgSQL, and not being able to reorder columns easily is one feature I really miss in PG.

[ Parent | on HN ]