Re: Patch to allow setting schema/search_path in the connectionURL - Mailing list pgsql-jdbc

On 9/22/2014 10:02 PM, stagirus wrote:
> I thought the following context might be helpful. We have been using Oracle.
> It conveniently and transparently relates a user to a schema.

postgres' default search_path is $USER,public...  so if there's a schema
the same name as the user role, then it will look for objects there
before it looks in public... which as far as I can tell is exactly what
you're saying Oracle does.



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