[postgis-users] PostGIS on multiple schemas

Arnaud Lesauvage thewild at freesurf.fr
Thu Jan 12 06:13:55 PST 2006


Don Drake wrote:
> I would try just leaving it where it is and adding:
> search_path = '$user,public,my_old_schema'
> 
> to postgresql.conf.
> 
> It's easier if you keep PostGIS in public when you add schemas, then you
> won't have to deal with these problems.

Having my first schema in the default search_path (in 
postgresql.conf), I think I will keep it that way.
I agree that it would have been best practice to keep all public 
things into public, and to add specific schemas for specific things.

Thanks for the suggestion.

--
Arnaud




More information about the postgis-users mailing list