Re: Schemas: status report, call for developers

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> What about "CREATE USER tgl WITH SCHEMA;"  ?

Uh, what about it?  It's not a standard syntax AFAIK.

If I were running an installation where I wanted "one schema per user"
as default, I'd rather have an "auto_create_schema" SET parameter that
told CREATE USER to do the dirty work for me automatically.

But the sneaky part of this is that users are installation-wide,
whereas schemas are only database-wide.  To make this really work
painlessly, you'd want some kind of mechanism that'd auto-create
a schema for the user in every database he's allowed access to.
How can we define that cleanly?
        regards, tom lane