Can’t you do effectively the same with schemas? Something like create schema foo; grant all on all tables in schema foo to foo; would allow role “foo” to

Can’t you do effectively the same with schemas? Something like create schema foo; grant all on all tables in schema foo to foo; would allow role “foo” to “create/delete/manage databases in schema foo, such as foo.foo_dev, foo.foo_test, foo.foo_prod, etc. Or do you want a second level (possibly a hierarchy) of schemas?