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
"Matthew Nuzum" <[EMAIL PROTECTED]> writes:
> Thanks for the very quick reply... I didn't know about the dbsize stuff,
> they may help. Unfortunately, the records are mixed together.
When measuring the on-disk size of a table, don't forget to include its
indexes and its toast table (and the toast
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
