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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
