[postgis-users] MacPorts/PostGIS - Installation in different Schema

[Kevin Neufeld]

Hi Stefan,

As far as I know, following other PostgreSQL contrib modules, PostGIS 
currently only installs in the public schema (unless someone has put 
some work into this).  As I mentioned, this is the same for most other 
contrib modules, like tsearch2, btree_gist, or cube.  So, if ever you 
wanted to install other PostgreSQL extensions, their functions / 
datatypes / tables would also install in public, getting mixed up with 
tables/functions you've defined there.

The solution here is simple.  As a best practice, reserve the public 
schema for contrib modules, storing user-defined tables / functions / 
objects in user-defined schemas.  Following this best practice also 
makes upgrading PostGIS significantly simpler since you can simply dump 
and restore your user-defined schema (rather than hunting through the 
public schema trying to determine which functions are yours, postgis's, 
cube's, tsearch2's, etc.)

Cheers,
Kevin

-------------
Kevin Neufeld
Software Developer
Refractions Research Inc.
300-1207 Douglas St.
Victoria, B.C., V8W 2E7

Phone: (250) 383-3022
Email: kneufeld at refractions.net



Stefan Schwarzer wrote:
>
> Hi there,
>
> I would like to know if somebody could tell me how I can - by using 
> the PostGIS MacPort - install the postgis functions not in the schema 
> "public", but in another schema (to separate it from the tables which 
> are being inserted into the public schema).
>
> Thanks for any hints,
>
> Stef
>
>  ____________________________________________________________________
>
>   
>
>   Lean Back and Relax - Enjoy some Nature Photography
>   http://photoblog.la-famille-schwarzer.de 
> <http://photoblog.la-famille-schwarzer.de/>
>
>   Appetite for Global Data? UNEP GEO Data Portal:  
>   http://geodata.grid.unep.ch <http://geodata.grid.unep.ch/>
>   ____________________________________________________________________
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>