Permission denied while importing data from a file? - Mailing list pgsql-general

From Felix Slager
Subject Permission denied while importing data from a file?
Date
Msg-id 38F0ACDC.CBCE5538@hydra.accu.uu.nl
Whole thread Raw
Responses Re: Permission denied while importing data from a file?  (Charles Tassell <ctassell@isn.net>)
List pgsql-general
LS,

i'm trying to copy data into a table using a copy command using:

COPY tabelName FROM '/somewhere/somebody/datafile.txt';

I've given everybody the right to use the datafile.txt (execute, read,
write) with an incredible chmod 7777. Still i get the message:

ERROR:  COPY command, running in backend with effective uid nr 666,
could not open file '/somewhere/somebody/datafile.txt' for reading.
Errno = Permission denied (13).

Why? I mean how does this happen?
Please help...

Felix

pgsql-general by date:

Previous
From: Ron Peterson
Date:
Subject: recursive queries?
Next
From: fdpmjw@myhome.net
Date:
Subject: Giving A DOG HEAD !!! Doggy blow job! 6158