Cannot copy CSV file to postgres database using goose due to denied permissions
Issue #70
new
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?