Try moving the file into /tmp and seeing if that works. Sometimes you run
into problems with having permissiosn on the file, but not all of the
directories before it. You must have execute permissions on all parent
directories in order to access a file in one of those dirs. The file will
only need read access (444), although the others won't stop it from working
(it will just be less secure if you are on a multi-user system.)
Also, I believe that one of the copy commands (either \copy or the COPY SQL
command) can only be done as the database super user (postgres or pgsql,
depending on how you installed Postgres) Maybe you are using the wrong one?
At 01:16 PM 4/9/00, you wrote:
>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