Comment by tianzhou

FWIW, I built pgschema https://github.com/pgplex/pgschema which is a declarative approach to manage this.