On Thu, Mar 29, 2012 at 2:39 PM, Jonathan Bartlett <[email protected]> wrote: > Tom - > > 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. > > Does this sound reasonable?
It's pretty much what I was going to suggest. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
