Jonathan Bartlett wrote on 29.03.2012 22:39:
Your suggestion gives me an idea, and I'd like your opinion since I haven't 
done much with schemas.

(1) Separate the datasets into different schemas
(2) Use different schema names for different static data releases
(3) For the *company*, we can use a schema search path that includes the next 
schema
(4) For the *users*, they can use a schema search path that includes the 
released schema

Then, I wouldn't have to modify any code, except to set the schema search path 
based on who was connecting.

If you create different Postgres users, you can set the search_path per user, 
so you don't have to remember doing that while connecting.





--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to