[postgis-users] Multiple Schemas with PostGIS

[Stephen Woodbridge]

strk at refractions.net 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