On Mon, Aug 30, 2021 at 11:56 PM Miles Elam <miles.elam@xxxxxxxxxxxxxx> wrote: > > Not sure that querying the catalogs is strictly necessary though… Could you say more? I meant for anything that doesn't have an IF [NOT] EXISTS, including cases where such a clause wouldn't be possible. For instance if you have to provide an upgrade script that change a column datatype. As Adrian mentioned, sqitch should provide a sensible framework for that, but there may be similar tools more suitable for your environment if you're already using other frameworks.
