Re: Question to schema public - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Question to schema public
Date
Msg-id D960CB61B694CF459DCFB4B0128514C22FC1F8@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Question to schema public  ("Kai Behncke" <Kai-Behncke@gmx.de>)
List pgsql-general
Kai Behncke wrote:
> If I create on my system (Postgresql 8.2.4) a new database it
> gets automatically the schema public.
>
> I would like to know what this schema is for?

It is kind of a "default schema". If you keep the standard
configuration, then every user can access objects in this schema
without specifying a schema name.

If you don't need schema public, you can also delete it without
breaking anything.

> On my system I have a couple of different users.
> The owner of the public-schema is postgres.
>
> Could it be Fatal to give all of my users the maximum
> permissions to change that public schema? What could be the result?

That shouldn't be a problem. It means that
a) every user can create objects in this schema
b) every user can access objects in this schema
   (IF the object allows it)

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: Database/Table Design for Global Country Statistics
Next
From: Ron Johnson
Date:
Subject: Re: Database/Table Design for Global Country Statistics