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
