[postgis-users] schema

[Liford, Michael W.]

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