How do I copy a CSV file into a Postgres Table?

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);