Permission denied while importing data from a file?

From: Felix Slager <slager(at)hydra(dot)accu(dot)uu(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Permission denied while importing data from a file?
Date: 2000-04-09 16:16:28
Message-ID: 38F0ACDC.CBCE5538@hydra.accu.uu.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Peterson 2000-04-09 16:25:16 recursive queries?
Previous Message Michael Hall 2000-04-09 15:57:54 Selecting field names?