Re: JDBC - setting PG variables in URL - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: JDBC - setting PG variables in URL
Date
Msg-id 463F8EEC.8010004@commandprompt.com
Whole thread Raw
In response to JDBC - setting PG variables in URL  ("Jan Bilek" <bilekj@gmail.com>)
List 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 by date:

Previous
From: "Jan Bilek"
Date:
Subject: JDBC - setting PG variables in URL
Next
From: Rich Shepard
Date:
Subject: Re: Date Math