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