title: How to populate a heroku postgresql database with a sql file
body: <p>First of, I want to say, that I am not a DB expert and I have no experience with the heroku service.</p>
  
  <p>I want to deploy a play framework application to the heroku service. And I need a database to do so. So I created a postgresql database with this command, since it's supported by heroku:</p>
  
  <pre><code>Users-MacBook-Air:~ user$ heroku addons:create heroku-postgresql -a name_of_app
  </code></pre>
  
  <p>And I got this as response</p>
  
  <pre><code>Creating heroku-postgresql on ⬢ benchmarkingsoccerclubs... free
  Database has been created and is available
  ! This database is empty. If upgrading, you can transfer
  ! data from another database with pg:copy
  </code></pre>
  
  <p>So the DB is now existing but empty of course. For development I worked with a local H2 Database. </p>
  
  <p>Now I would want to populate the DB on heroku using a sql file, since it's quite a lot of data. But I couldn't find how to do that. Is there a command for the heroku CLI, where I can hand over the sql file as an argument and it populates the database? The File basically consists of a few tables which get created and around 10000 Insert commands.</p>
  
  <p>EDIT: I also have CSV files from all the tables. So if there is a way how I can populate the Postgres DB with those would be also great</p>