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

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Patch to allow setting schema/search_path in the connectionURL
Дата
Msg-id 542100AD.9000701@hogranch.com
обсуждение исходный текст
Ответ на Re: Patch to allow setting schema/search_path in the connectionURL  (stagirus <mamasa@stagirus.com>)
Ответы Re: Patch to allow setting schema/search_path in the connectionURL
Список 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



В списке pgsql-jdbc по дате отправления:

Предыдущее
От: stagirus
Дата:
Сообщение: Re: Patch to allow setting schema/search_path in the connectionURL
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Patch to allow setting schema/search_path in the connectionURL