I have added many new columns to a table in my database in my local environment with
ADD COLUMN statements, over 30. My application is split into multiple environments (UAT, STAG, PROD) and we are NOT using a DB toolkit like RedShift or SQAlchemy or DjangoORM. I need to get those 30 columns (no data, just the blank column definitions) added to the same table in the databases on the UAT environment, the staging environment, and the production environment.
Is there an easy way to do this? I could of course write 30
ALTER TABLE xxx ADD COLUMN xxx statements and run those statements in each environment, but isn't there a less tedious way? Perhaps I can dump the table in my local environment as
ADD COLUMN statements and then just copy and run the statements corresponding to the new columns I added in each of the environments?