Computer: Mac OS X, version 10.8 Database: Postgres Trying to import csv file into postgres. Pg>copy items_ordered from '/users/darchcruise/desktop/items_ordered.csv' with CSV; ERROR: could not open file '/users/darchcruise/desktop/items_ordered.csv' for reading: Permission denied Then I tried $>chown postgres /users/darchcruise/desktop/items_ordered.csv chown: /users/darchcruise/desktop/items_ordered.csv: Operation not permitted Lastly, I tried $>ls -l -rw-r--r-- 1 darchcruise staff 1016 Oct 18 21:04 items_ordered.csv Any help is much appreciated! Copy your CSV file into the /tmp folder Files named in a COPY command are read or written directly by the server, not by the client application.

I'm doing a work for the university, and I have a problem When I try to read a file (jpg, txt, or whatever) PostgreSQL returns: ERROR: could not open server file. Polisano Baneasa Program. Home >Could Not >How To Increase Utorrent Speed On Windows 7 more. Could Not Open File For Reading Permission Denied Postgres Could Not Open File For Reading Permission Denied Postgres.

Therefore, they must reside on or be accessible to the database server machine, not the client. They must be accessible to and readable or writable by the PostgreSQL user (the user ID the server runs as), not the client. COPY naming a file is only allowed to database superusers, since it allows reading or writing any file that the server has privileges to access.