Add PostgresSchema CR #151
Description
Hi there. I am looking for a Postgres operator that can manage the Postgres DDL via CRs, and this project comes the closest thanks to the PostgresUser CRD.
My use case is that I want an admin user to be able to provision a long-lived Postgres cluster, but then lesser-privileged users will be able to submit PostgresUser and PostgresSchema CRs to create schemas and users without having to edit the Postgres CR. I'm looking at CI pipelines which run automated tests where they need to create a Postgres database as part of the tests, and tear it down after. It's quite slow to provision a whole cluster, but it would be much faster to provision a schema + user on an existing cluster.
Every operator I have looked at so far requires editing the Postgres CR at the global scope to add schemas and users. This one offers PostgresUser but it just needs PostgresSchema and it will be complete (for me).
Would you consider putting this feature on the roadmap? Thanks