On Wed, 30 Nov 2022 at 17:35, 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.
It might be worth mentioning AUTHORIZATION. The easiest way to create an appropriately named schema for a user is "CREATE SCHEMA AUTHORIZATION username".