3 ms·

Reordering columns.

• muhehe 4y ago
  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)
  • sa46 4y ago
    Helps reduce storage space by better aligning columns to reduce padding. https://www.2ndquadrant.com/en/blog/on-rocks-and-sand/ https://www.2ndquadrant.com/en/blog/on-rocks-and-sand/
  • mekster 4y ago
    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.
• sroussey 4y ago
  Create a view?
  • barryp 4y ago
    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.