Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I set the schema search path in a datasource config for a connection pool? - Mailing list pgsql-general

From Bjørn T Johansen
Subject Re: How do I set the schema search path in a datasource config for a connection pool?
Date
Msg-id 20090215175629.4a24776e@pennywise.havleik.no
Whole thread Raw
In response to Re: How do I set the schema search path in a datasource config for a connection pool?  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
On Sun, 15 Feb 2009 08:47:36 -0700
Scott Marlowe <scott.marlowe@gmail.com> wrote:

> On Sun, Feb 15, 2009 at 5:58 AM, Bjørn T Johansen <btj@havleik.no> wrote:
> > I can't find a way to do this, what am I missing?
>
> You can either issue the command when you open the connection, alter
> the user the connection uses, or alter the database to default to that
> search path.
>
> alter user bubba set search_path='path1','path2';
>

Yes, alter user worked fine... Thx... :)

BTJ

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: How do I set the schema search path in a datasource config for a connection pool?
Next
From: Michal Politowski
Date:
Subject: partial unique index and the planner