If you have a language installed (like pl/pgsql), then dropping the public
schema also drops the language. Ouch.
Maybe there is a solution to that one though...
John Sidney-Woollett
Kris Jurka said:
>
>
> On Wed, 31 Dec 2003, Mike Nolan wrote:
>
>> That raises an interesting question. Can pg be configured so
>> that user tables MUST be in user schemas, i.e., nobody can put tables
>> in the PUBLIC schema?
>
> Sure, you can simply drop the public schema, or "revoke all on schema
> public from public";
>
> Kris Jurka
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>