Re: [GENERAL] Question to schema public

2007-09-12 Thread Albe Laurenz
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

Re: [GENERAL] Question to schema public

2007-09-12 Thread Richard Huxton
Kai Behncke wrote: Dear list, 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? On my system I have a couple of different users. The owner of the public-schema is postgres. By default everyone get

[GENERAL] Question to schema public

2007-09-12 Thread Kai Behncke
Dear list, 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? 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 th