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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
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 15:47:36
Message-ID: dcc563d10902150747k48a57943wf1409dcf8193d934@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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';

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bjørn T Johansen 2009-02-15 16:56:29 Re: How do I set the schema search path in a datasource config for a connection pool?
Previous Message Osvaldo Kussama 2009-02-15 15:16:31 Re: Array in nested query