title: How to add a user to PostgreSQL in Windows?
body: <p>I'm running PostgreSQL on mt Windows 7 machine.  To run a database I type:</p>
  
  <pre><code>C:\psql -Upostgres mydb
  </code></pre>
  
  <p>and this works, but it would be nice if I could leave off the <code>-U</code> stuff, but then Postgres thinks I'm trying to log in as 'Eric', since that is my user profile.</p>
  
  <p>So I need to add a user to Postgres, obviously.  But how?  If I try:</p>
  
  <pre><code>C:\createuser Eric
  </code></pre>
  
  <p>Postgres thinks I'm trying to add a user Eric <em>as the user Eric</em> which fails.  Adding the <code>-U</code> flag doesn't seem to work here.</p>
  
  <p>What am I missing?  My command window is in administrator mode, and there is no <code>sudo</code> available, obviously.</p>