title: How do I run test cases in postgresql?
body: <p>I want to drop/create a database, run my test cases every time I run my app. From my understanding postgresql must know the database when it creates the connection. So when I write this</p>
  
  <pre><code>new NpgsqlConnection("host=localhost;username=foo;password='bar';");
  </code></pre>
  
  <p>postgresql will automatically use the database foo. Because I'm using foo I can't drop/create it. So my question is how do I drop/create a database each time I run my app and is it possible to have an in memory database?</p>