Обсуждение: PostgreSQL JDBC support for runtime configuration options

Поиск
Список
Период
Сортировка

PostgreSQL JDBC support for runtime configuration options

От
"Collin Peters"
Дата:
Hi all,

Just wondering if the JDBC driver has support for PostgreSQL's runtime
configuration options listed here:
http://www.postgresql.org/docs/8.0/interactive/runtime-config.html

So for example the SQL "SET time zone 'EST'" or "SET datestyle TO
Postgres, Euro"

Regards,
Collin Peters

Re: PostgreSQL JDBC support for runtime configuration options

От
Oliver Jowett
Дата:
Collin Peters wrote:

> Just wondering if the JDBC driver has support for PostgreSQL's runtime
> configuration options listed here:
> http://www.postgresql.org/docs/8.0/interactive/runtime-config.html
>
> So for example the SQL "SET time zone 'EST'" or "SET datestyle TO
> Postgres, Euro"

You can run that SQL directly, there's no special support needed.
However changing datestyle in particular will cause the JDBC driver to
be unhappy.

-O