Обсуждение: external environment variable

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

external environment variable

От
"Randal Flagg"
Дата:
Hi!!,  I've a little problem. I've installed Apache JServ 1.03b and it 
works very good, I've also installed PostreSQL 6.4 and I set the 
environment variable PGDATESTYLE in the /etc/profile file. When I use 
PostgreSQL directly, date's fields are shown according to the 
PGDATESTYLE but, when I query a table across the Web using a Servlet 
PostreSQL ignore PGDATESTYLE and use it's default.

Best regards, Flagg_Randal@hotmail.com

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com


Re: [SQL] external environment variable

От
José Soares
Дата:

Randal Flagg ha scritto:

> Hi!!,
>    I've a little problem. I've installed Apache JServ 1.03b and it
> works very good, I've also installed PostreSQL 6.4 and I set the
> environment variable PGDATESTYLE in the /etc/profile file. When I use
> PostgreSQL directly, date's fields are shown according to the
> PGDATESTYLE but, when I query a table across the Web using a Servlet
> PostreSQL ignore PGDATESTYLE and use it's default.
>

use command set
Description: set run-time environment
Syntax:       SET DateStyle TO
'ISO'|'SQL'|'Postgres'|'European'|'US'|'NonEuropean'

example:
set datestyle to 'ISO';
José