Re: [GENERAL] how to use multiple schema's

2009-09-02 Thread Himanshu Gupta
, Himanshu Gupta 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

Re: [GENERAL] how to use multiple schema's

2009-09-02 Thread Himanshu Gupta
Hi Scott, Thanks for response, bit if I point it to all the schema, I am just wondering how data insertion will work, I have multiple ables with same name in these applications. -HImanshu On Sep 2, 2009, at 10:48 AM, Scott Marlowe wrote: you just set search_path to point to all the sche

[GENERAL] how to use multiple schema's

2009-09-01 Thread Himanshu Gupta
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