News for hackers. Stuff that matters.
Re:Surviving Without a Superuser in Postgres 16 by Someone on Thursday January 26, 2023 @04:14PM (#34538946)
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?

Re:Surviving Without a Superuser in Postgres 16 by chungy on Thursday January 26, 2023 @04:23PM (#34539034)
Schemas are underneath databases, but same idea :)