Re: [HACKERS] Schemas: status report, call for developers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> I don't have a better idea, but I am wondering how this will work. If I
> create a schema with my name, does it get added to the front of my
> schema schema search path automatically,

Yes (unless you've futzed with the standard value of search_path).

> If I want to prevent some users from creating tables in my database, do
> I remove CREATE on the schema using REVOKE SCHEMA, then create a schema
> for every user using the database?

Well, you revoke world create access on the public schema (or maybe even
delete the public schema, if you don't need it). I don't see why you'd
give people their own schemas if the intent is to keep them from
creating tables.

regards, tom lane