1
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

GlaceCelery
  • 921
  • 1
  • 13
  • 30

0 Answers0