Martin,
Can you explain this a little further?
My client-application would somehow set the the environment-variable
PGUSER e.g. to 42.
Then create an odbc connection with user='john' and password='doe' to
the remote pg-server.
Later the triggers that run on the server would access this client-local
environment-variable for updates?
How can the server-located function see client-local Env-Vars ?
Regards
Andreas
Martin Gainty schrieb:
> http://www.postgresql.org/docs/8.3/static/libpq-envars.html
> use environment variables
>
> PGHOST is the host for Postgres
> PGHOSTADDR is the Numeric Host Address for Postgres
> PGPORT is the port for the PostgresServer to listen on
> PGDATABASE is the default Database Name
> PGUSER is the default Username to use to login
> PGPASSWORD is the password to use for default Username to login
>
> M--
>
> ----- Original Message -----
> From: "Scott Ribe" <scott_ribe@killerbytes.com>
> To: "Andreas" <maps.on@gmx.net>; <pgsql-general@postgresql.org>
> Sent: Saturday, October 13, 2007 11:05 AM
> Subject: Re: [GENERAL] can I define own variables?
>
>
>
>>> can I define connection-global variables within a ODBC connection ?
>>>
>> Temp table, containing only 1 row, one column per variable. If you so
>>
> wish,
>
>> wrap it up in stored procedures for creating, setting, and accessing.
>>
>> --
>> Scott Ribe
>> scott_ribe@killerbytes.com
>> http://www.killerbytes.com/
>> (303) 722-0567 voice
>>
>>
>>
>> ---------------------------(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
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>