One thought on “Notes: To import a csv into a heroku table

  1. John says:

    I need to change it slightly to work for me: psql `heroku config:get DATABASE_URL -a your_app_name`?ssl=true -c “\copy company_infos(email, url, created_at, updated_at) FROM ‘/Users/john/company_infos_heroku4.csv’ WITH(FORMAT csv, HEADER true);”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s