BUG #16798: SQL Error

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

BUG #16798: SQL Error

apt.postgresql.org Repository Update
The following bug has been logged on the website:

Bug reference:      16798
Logged by:          Oluwasola Arigbabowo
Email address:      [hidden email]
PostgreSQL version: 10.0
Operating system:   Windows 10

I encountered an error when I was trying to copy a csv file into a table
created in a database inside the server. The code I used is :

Copy Customer from 'C:\\Users\\okari\\Customer.csv' delimiter ',' csv

and the error that resulted is given below.

ERROR:  could not open file "C:\\Users\\okari\\Customer.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

I would appreciate some help with this.