Good Evening Andreas- Windows Control Panel/System/Advanced/EnvironmentVariables/Set System Variables as mentioned PGHOST=localhost all processes for all users will see these env vars Unix bash (to set system wide variables) go to /etc/profile vi .profile PGHOST=localhost export PGHOST :w! :q Hope this helps/ Martin-- ----- Original Message ----- From: "Andreas" <maps.on@xxxxxxx> To: "Martin Gainty" <mgainty@xxxxxxxxxxx> Cc: <pgsql-general@xxxxxxxxxxxxxx> Sent: Sunday, October 14, 2007 1:30 PM Subject: Re: can I define own variables? > 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/ > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
