[postgis-users] schema

[Kevin Neufeld]

Sorry, I think there's a confusion here of terminology.  I meant to say you only need to spatial enable a PostgreSQL 
database once (that is, you only need to import the lwpostgis.sql and spatial_ref_sys.sql files once into your 
database).  You don't need to import the functions into every schema.

-- Kevin

Liford, Michael W. wrote:
> I finally got PostGIS to install by not creating the spatial database.
> Seems that is where the problem is. 
> 
> Mike
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> Kevin Neufeld
> Sent: Tuesday, December 22, 2009 12:22 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] schema
> 
> You only need to install PostGIS once, into one schema, typically
> 'public'.    As long as your user's search_path 
> contains the schema you installed PostGIS into, you'll have access to
> all the PostGIS functions, no matter what schema 
> you are referencing.
> 
> You can read up on schemas here:
> http://www.postgresql.org/docs/8.4/static/ddl-schemas.html
> 
> Cheers,
> Kevin
> 
> Malm Paul wrote:
>> Hi,
>> how can I create a secondary schema that includes all postgis
> functions as the default schema does?
>> Kind regards,
>> Paul 
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users