Re: how to use multiple schema's

OOPS I got caught by the reply verses reply-all and only sent this to
Scott. Plus I see it has already been addressed in a later message.

raa

Scott Marlowe wrote:
> So, can you just set search_path to point to all the schemas at once
> then? Or does that not meet your needs?

The only issue I see is if two or more of the "applications" have a
table named the same, like "users". Which gets used? The first found
in the search_path?

\\||/
Rod
--
>
> On Wed, Sep 2, 2009 at 7:19 AM, Himanshu
> Gupta<himanshu(dot)gupta(at)semanticbits(dot)com> wrote:
>> I want single user to see all the schema at once. Database server is on
>> client side and it takes time to get new user or new database instance, So i
>> am trying to find a workaround for that.
>>
>> Thanks,
>> Himanshu
>>
>> On Sep 1, 2009, at 6:04 PM, Scott Marlowe wrote:
>>
>>> On Tue, Sep 1, 2009 at 2:58 PM, Himanshu
>>> Gupta<himanshu(dot)gupta(at)semanticbits(dot)com> wrote:
>>>> Hi,
>>>>
>>>> I have multiple applications, i want to create separate schema for each
>>>> of
>>>> the application. I dont want to change search path, since have only one
>>>> user. I went through couple of post's talking about some patch related to
>>>> that. It seems that patch got rejected. Any help is appreciated.
>>> I'm not sure how you want this to happen. Do you want a single user
>>> to see ALL the schemas at once? Or do you want to set the search path
>>> each time you connect? Is there a reason for having multiple apps hit
>>> multiple schemas but use only one account? Multiple accounts (one for
>>> each app) would certainly make things more manageable.
>>>
>>> But mainly I'm just trying to get a grip on how you're trying to get
>>> this to work.
>>
>
>
>