if you want to import a csv to a heroku table, execute the following command:
psql `heroku config:get DATABASE_URL -a your_app`?ssl=true -c "\copy your_table FROM '/tmp/rows.csv' WITH CSV;"
Replacing your_table
and your_app
with the appropriate info