Joerg Hessdoerfer wrote:
>On Thursday 12 August 2004 06:25, Tom Lane wrote:
>
>
>>"efesar (the kay)" <efesar@unm.edu> writes:
>>
>>
>>>The 8.0 version does not acknowledge env vars like PGPASSWORD and seems
>>>to ignore the contents of the .pgpass file.
>>>
>>>
>>Hmmm. Those are probably the same problem, since finding .pgpass
>>depends on expanding the $HOME env var. But I have no idea why
>>env vars aren't working for you ...
>>
>>
>Yep. AFAIK, $HOME doesn't always exist in WIN32, but $HOMEDRIVE and $HOMEPATH
>(or %HOMEPATH% and %HOMEDRIVE% ;-) do. Perhaps PG needs to do some munging to
>build the home path from those two?
>
>
>
>
On my XP-Pro machine the appropriate setting appears to be %USERPROFILE%
- %HOMEPATH% is just "\"
See here for a complete list of available environment vars:
http://www.winnetmag.com/Article/ArticleID/23873/23873.html
cheers
andrew