[postgis-users] schema
Kevin Neufeld
kneufeld at refractions.net
Tue Dec 22 15:05:10 PST 2009
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
More information about the postgis-users
mailing list