On Wed, Nov 30, 2022 at 3:35 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > > BTW, is "create a schema with the same name" sufficient detail? > You have to either make it owned by that user, or explicitly > grant CREATE permission on it. I'm not sure if that detail > belongs here, but it feels like maybe it does. > > I'd mention the ownership variant and suggest using the AUTHORIZATION clause, with an explicit example.
CREATE SCHEMA role_name AUTHORIZATION role_name; David J.