Hacker News Reader

Reordering columns.

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)

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

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

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.

Create a view?

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.

Reply on news.ycombinator.com