On Thu, Mar 29, 2012 at 2:39 PM, Jonathan Bartlett <jonathan@xxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
