title: How to force psql to detect .pgpass file on Windows 10 system?
body: <p>I am working on Windows 10 system, python 3.9.4 in, anaconda env.
  I have a <code>.pgpass</code> file: <code>localhost:port:db_name:user_name:password</code></p>
  <p>When I run:</p>
  <pre class="lang-none prettyprint-override"><code>psql -U user_name -d db_name -pXXXX
  </code></pre>
  <p>OR</p>
  <pre class="lang-none prettyprint-override"><code>psql -U user_name -d db_name -pXXXX -f /path/to/sql/file.sql
  </code></pre>
  <p>it prompts me for a password. When I enter the password I can connect, but I would like psql to pick up the pgpass file instead.</p>
  <p>My theory is: The format of the pgpass. Does it require specific EOL characters on Windows system?</p>
  <pre class="lang-none prettyprint-override"><code>localhost:port:db_name_1:user_name_1:password_1 &lt;CR or LF&gt;
  localhost:port:db_name_2:user_name_2:password_2 &lt;CR or LF&gt;
  </code></pre>