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@xxxxxxxxxxxxxxx>
To: "Andreas" <maps.on@xxxxxxx>; <pgsql-general@xxxxxxxxxxxxxx>
Sent: Saturday, October 13, 2007 11:05 AM
Subject: Re: 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@xxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
