[postgis-users] Several Schemas in a spatial Database

[Andreas Neumann]

no, its not necessary. Those two columns and the functions are just stored
once in the "public" schema. In the "geometry_columns" table you'll notice
a column for the schema-name, which tells postgis in which schema the
geometry table lives in.

Andreas

> 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?
> Thanks in advanced.
> Gabriella.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
Andreas Neumann
Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland
Email: a.neumann at carto.net, Web:
* http://www.carto.net/ (Carto and SVG resources)
* http://www.carto.net/neumann/ (personal page)
* http://www.svgopen.org/ (SVG Open Conference)
* http://www.geofoto.ch/ (Georeferenced Photos of Switzerland)