Re: Problem with sql COPY command - Mailing list pgsql-general

From Richard Poole
Subject Re: Problem with sql COPY command
Date
Msg-id 20040827221625.GA20455@guests.deus.net
Whole thread Raw
In response to Problem with sql COPY command  ("Jon Asher" <jon@vagabond-software.com>)
Responses Re: Problem with sql COPY command - FIXED  ("Jon Asher" <jon@vagabond-software.com>)
List pgsql-general
On Fri, Aug 27, 2004 at 03:03:34PM -0700, Jon Asher wrote:

> COPY fails with this error message:
> could not open file "/root/Desktop/server_transfer/WorldPoints_v2.txt" for
> reading: Permission denied

Don't forget that you'll need to set permissions on all the intermediate
directories as well as the file itself. It is probably safer to put the
file somewhere else than to make /root world-accessible. /tmp or an
ordinary user's home directory would be possibilities.


Richard

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Problem with sql COPY command
Next
From: Tino Wildenhain
Date:
Subject: Re: Problem with sql COPY command