« Return to Thread: Multiple Schemas with PostGIS

Re: Multiple Schemas with PostGIS

by Stephen Woodbridge :: Rate this Message:

Reply to Author | View in Thread

strk@... wrote:

> On Mon, Jan 15, 2007 at 02:18:12PM +0100, Stefan Schwarzer wrote:
>> Hi,
>>
>> I would like to place my postgis libs into another schema; or  
>> eventually have two schemas with the postgis extension.
>>
>> An older message ( http://postgis.refractions.net/pipermail/postgis- 
>> users/2006-January/010602.html ) indicates that it is not possible to  
>> have postgis in multiple schemas.
>>
>> Is this still the status quo? Or has this changed and then how can I  
>> install postgis in another schema?
>
> Nothing changed in this reguard. The hard part is PL/pgsql functions
> in need to know where postgis is installed. Might be done at build
> time, but then your enabler script will be bound to your specific
> configuration. IIRC later pgsql version behave more nicely.

We use it all the time installed a one schema and referenced in another
schema. We control this by setting up users and search_path.

-Steve
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

 « Return to Thread: Multiple Schemas with PostGIS