Re: Managing two sets of data in one database

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
whileconnecting.