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