Re: Patch to allow setting schema/search_path in the connectionURL - Mailing list 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