I have a table in production whose structure I want to modify. I can ALTER the table to add column but the column gets added at the end, may be the order may not matter. But at least visually I see it as the last column. The table was created at the last release and it was empty. So, I thought of dropping it & re-creating it in my flyway script. But it led to build failure as the database replication is on in production. How to deal with it? Database is PostgreSQL. At this point of time, I do not have information about scheme of replication as the production environment is with client.