Updating column rows in MySQL is pretty trivial, and I've wondered why it's not the same in Postgres, even at the GUI level.

Ordering columns for performance might be a different order of reccomendation.