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: [email protected]
[mailto:[email protected]] 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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
