[postgis-users] Several Schemas in a spatial Database

[Brent Wood]

--- Gabriela Messner <gabmessner at gmail.com> wrote:

> I need to create several Schemas in a spatial database in order to classify
> my layers.
> Is it necessary to inherit the "geometry_columns" and "spatial_ref_sys" from
> the public Schema to the others schemas?

Nope, though it is simpler if you keep those tables in the public schema, to be
always available.

If you have not used multiple schemas before, check/modify the search_path in
postgresql.conf, to access tables in schemas without explicitly using schema
names. 

Cheers,

   Brent Wood