https://wiki.postgresql.org/wiki/Alter_column_position The three workarounds from this article are: Recreate the table Add columns and move data Hide the differences with a view