COPY test
FROM 'C:\Users\micro\Downloads\test.csv' CSV HEADER;
I have shared the download directory (right click, properties etc.) and I get this error:
ERROR: could not open file "C:\Users\micro\Downloads\test.csv" for reading:
Permission denied
HINT: COPY FROM instructs the PostgreSQL server process to read a file. You
may want a client-side facility such as psql's \copy.
SQL state: 42501
Using "\COPY" gives a syntax error
Many thanks