On 10/02/2009 21:47, Sam Mason wrote: > On Tue, Feb 10, 2009 at 07:22:24PM +0100, IIIigo Barandiaran wrote: >> What does "visible to the script" means? > > Each command interpreter has its own set of variables; you need to set > them in the correct one. For example, starting one copy of "cmd" and > typing "SET var=value" and then closing it and starting another one and > running your "script" won't work because they are different interpreters > (i.e. different instances, or processes, of the same executable, or > program). > > If you're executing "SET ..." in one command interpreter and then double > clicking on your script (a .bat file?) then you're effectively starting > another interpreter on that one script, it will exit when it's reached > the end of your script. I couldn't have put it better! :-) You could create a system-wide environment variable via right-clicking on My Computer, selecting properties, then clicking "Environment variables" - but this is a *really* bad idea for storing a password, as it's visible to anyone using the computer. Far better to use the .pgpass file. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
