Re: Patch to allow setting schema/search_path in the connectionURL

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Patch to allow setting schema/search_path in the connectionURL
Date: 2014-09-23 05:00:59
Message-ID: 5420FE8B.7070109@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 9/22/2014 9:53 PM, stagirus wrote:
> I just tried as follows:
> ALTER ROLE dev SET search_path TO bep;
>
> Then ran a bunch of SQL commands after connecting to the user dev. But it
> fails because it is looking for the "public" schema. I am not sure how this
> "ALTER ROLE" works.

ALTER ROLE dev SET search_path TO bep,public;

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message stagirus 2014-09-23 05:02:57 Re: Patch to allow setting schema/search_path in the connectionURL
Previous Message stagirus 2014-09-23 04:55:21 Re: Patch to allow setting schema/search_path in the connectionURL