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:10:05
Message-ID: 542100AD.9000701@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message John R Pierce 2014-09-23 05:11:49 Re: Patch to allow setting schema/search_path in the connectionURL
Previous Message stagirus 2014-09-23 05:07:04 Re: Patch to allow setting schema/search_path in the connectionURL