So, can you just set search_path to point to all the schemas at once
then? Or does that not meet your needs?
On Wed, Sep 2, 2009 at 7:19 AM, Himanshu
Gupta<himanshu.gupta@semanticbits.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.gupta@semanticbits.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.
>
>
--
When fascism comes to America, it will be intolerance sold as diversity.