Skip to content

Instantly share code, notes, and snippets.

@StarWar
Forked from jboesch/pg_import_csv_to_heroku.sh
Created August 31, 2018 15:36
Show Gist options
  • Save StarWar/6c9dde38c4bf00f8cbead4c199fb7b9e to your computer and use it in GitHub Desktop.
Save StarWar/6c9dde38c4bf00f8cbead4c199fb7b9e to your computer and use it in GitHub Desktop.
Importing a CSV dump of Postgres data into Heroku
# You have your csv data and it looks like so... It's in a file named "my_data.csv" and we want to import it into a table named "my_things".
"1", "Something", "0.50", "2013-05-05 10:00:00"
"2", "Another thing", "1.50", "2013-06-05 10:30:00"
# Now you want to import it, go to the command line and type:
$ PGPASSWORD=PWHERE psql -h HOSTHERE -U USERHERE DBNAMEHERE -c "\copy my_things FROM 'my_data.csv' WITH CSV;"
# Voila! It's impoted. Now if you want to wipe it out and import a fresh one, you would do this:
$ heroku pg:psql
$ TRUNCATE table my_things;
Now re-do the PGPASSWORD command above:
$ PGPASSWORD=PWHERE psql -h HOSTHERE -U USERHERE DBNAMEHERE -c "\copy my_things FROM 'my_data.csv' WITH CSV;"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment