[postgis-users] schemas and postgis data

2011-09-22 Thread Robert Buckley
I have just read this explaining about how to structure data and functions within postgresql http://blog.cleverelephant.ca/2010/09/postgis-back-up-restore.html ...The public schema is where the PostGIS functions and system tables get installed, so if you dump that schema you get all those

Re: [postgis-users] schemas and postgis data

2011-09-22 Thread Ben Madin
Robert, You can get as complex as you like, but one great use of schemas (I think) has been to manage backing up data - especially over the internet, another is to manage user access at a more granular level. if you put your static data (ie background maps) into one schema, then when dumping