Issue
You want to copy a .csv
file from your local machine to a Heroku Postgres table.
Resolution
Run heroku pg:psql -a <application_name>
.
Once the Postgres shell opens, run
DATABASE=> \copy table_name FROM csv_file.csv WITH (FORMAT CSV);
You want to copy a .csv
file from your local machine to a Heroku Postgres table.
Run heroku pg:psql -a <application_name>
.
Once the Postgres shell opens, run
DATABASE=> \copy table_name FROM csv_file.csv WITH (FORMAT CSV);
Engage with a community of passionate experts to get the answers you need
Ask on Stack OverflowCreate a support ticket and our support experts will get back to you
Contact Heroku Support