title: CREATE USER produces 'NOTICE: empty string is not valid...'
body: <p>I'm following the PostgreSQL docs at <a href="https://www.postgresql.org/docs/11/sql-createuser.html" rel="nofollow noreferrer">https://www.postgresql.org/docs/11/sql-createuser.html</a> to create a user.  psql hates me.</p>
  
  <pre><code># CREATE USER blah WITH ENCRYPTED PASSWORD 'md56f1ed002ab5595859014ebf0951522d9';
  NOTICE:  empty string is not a valid password, clearing password
  CREATE ROLE
  </code></pre>
  
  <p>I generated the MD5 like...</p>
  
  <pre><code>$ md5 -s 'blah'
  MD5 ("blah") = 6f1ed002ab5595859014ebf0951522d9
  </code></pre>
  
  <p>How do I get the <code>NOTICE:  empty string is not a valid password, clearing password</code> to go away and have postgres respect my desire to present it with an encrypted password?</p>