Re: Problem with sql COPY command

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