Re: Managing two sets of data in one database

On 03/29/12 2:16 PM, Thomas Kellerer wrote:
> 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.

heck, the default search_path is $USER,"public"



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast