Cannot copy CSV file to postgres database using goose due to denied permissions

Issue #70 new
Former user created an issue

I created a database in postgres already for this csv file, and the names match.

I used the following SQL code for my data migration file: -- +goose Up COPY [database] FROM 'C:\absolute\path\to\CSV\file.csv' DELIMITER ',' CSV HEADER;

-- +goose Down DELETE FROM books;

However, when running a goose up (I tested my connection string already with other data migration files, and I confirmed that it works), it gives the following error:

goose run: FAIL pq: could not open file "C:\absolute\path\to\CSV\file.csv" for reading: Permission denied, quitting migration

How do you fix this?

Comments (0)

  1. Log in to comment