Re: How do I set the schema search path in a datasource config for a connection pool?

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How do I set the schema search path in a datasource config for a connection pool?
Date: 2009-02-15 16:56:29
Message-ID: 20090215175629.4a24776e@pennywise.havleik.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 15 Feb 2009 08:47:36 -0700
Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:

> On Sun, Feb 15, 2009 at 5:58 AM, Bjørn T Johansen <btj(at)havleik(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michal Politowski 2009-02-15 17:50:06 partial unique index and the planner
Previous Message Scott Marlowe 2009-02-15 15:47:36 Re: How do I set the schema search path in a datasource config for a connection pool?