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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
