title: Does anyone know how to create a new database (through code) on heroku?
body: <p>I'm confronted with a large number of clients all doing large number of transactions on distinct record sets. 
  I have say 100 clients each with 500k product records. 
  Previously I had separated their data with different schemas. It worked fine for a small time then we noticed that when one client was hammering the database all others would grind to a halt. </p>
  
  <p>We then moved to separate instances of Heroku.  Each client had their own application and thus their own database.  The problem with this is that on-boarding a new client means we have to fire up a new Heroku app and typically that task falls to a developer.  </p>
  
  <p>Ok.. so that's the background.<br>
  Now my question.  I want to create a new database on Heroku for each client.  (all in one "application"). When we on-board a new client my app will create the database and tie the username to that database. 
  I can create a database readily enough with something like this. </p>
  
  <pre><code>heroku addons:add heroku-postgresql:#{db_plan}
  </code></pre>
  
  <p>But what I don't know is how to get the username and password for this new database, so I can store it against the new user. </p>
  
  <p>QUESTION:  How does one get the user name and password for a database they created on heroku?</p>