Search path in connection string

Поиск
Список
Период
Сортировка
От Julien Demoor
Тема Search path in connection string
Дата
Msg-id CANE6ZrC-9KDdWgFbBF7jLChbiE7PtFfn2FcGoPyTRxGOj_C9Eg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Search path in connection string  ("David Johnston" <polobo@yahoo.com>)
Список pgsql-jdbc
There have been a number of messages on this list suggesting that the Postgres JDBC driver should support setting the search path as part of the connection string.

Can this be considered?

I have a use case where there doesn't appear to be any good alternatives: using BIRT, with multiple clients sharing a Postgres database with one schema each, one cannot just execute a SET SCHEMA statement (UPDATE pg_settings ... is not possible either) and qualifying object names is also not always possible (say, if there are stored procedures involved that use unqualified object names).

Besides being useful in this case and surely others, this feature makes sense: schemas can be used to offer separation of database objects very similar to that offered by having multiple databases, and the database itself is part of the connection string.


Regards,
Julien

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

Предыдущее
От: "David Johnston"
Дата:
Сообщение: Re: Opening view that uses a function - empty column
Следующее
От: "David Johnston"
Дата:
Сообщение: Re: Search path in connection string