Re: JDBC - setting PG variables in URL

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: JDBC - setting PG variables in URL
Дата
Msg-id 463F8EEC.8010004@commandprompt.com
обсуждение исходный текст
Ответ на JDBC - setting PG variables in URL  ("Jan Bilek" <bilekj@gmail.com>)
Список pgsql-general
Jan Bilek wrote:
> Hi,
> Is it possible to set any of postgre variables in JDBC conection URL?
>
> Example:
> "jdbc:postgresql://localhost:/dbname?pgvar1=value2&pgvar2=value2"
>
> Is this or simular construction plausible? We tried it, but it didn't
> work. OR - question could be put this way: How to set internal postgre
> variables (like search_path etc.) from Java2 enviroment using JDBC?

create a routine that the first thing it does on connect is use the
various SET commands that you need.

J


>
> Thanks for any hints.
>
> Regards,
> Jan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>


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

Предыдущее
От: "Jan Bilek"
Дата:
Сообщение: JDBC - setting PG variables in URL
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: Date Math