postgres add column at position
ALTER TABLE ADD COLUMN will only add the new column at the end, as the last one.
In order to create a new column in another position you need to recreate the
table and copy the data from the old/current table in this new table.