title: How to handle special characters in the password of a Postgresql URL connection string?
body: <p>Using a Postgresql URL connection string in the format of:</p>
  
  <pre><code>postgresql://user:secret@localhost
  </code></pre>
  
  <p>How do I handle special characters in that string (e.g., <strong>$</strong>) so that it will actually function when I connect to my postgres database?</p>
  
  <p>I've tried simply URL encoding it, so for example, "test$" becomes "test%24" ... but that seems to be a problem as I get a "FATAL: password authentication failed " error when attempting to use it.</p>