Re: Problem with sql COPY command

From: Richard Poole <rp(at)guests(dot)deus(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with sql COPY command
Date: 2004-08-27 22:16:25
Message-ID: 20040827221625.GA20455@guests.deus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2004-08-27 22:50:32 Re: Problem with sql COPY command
Previous Message Doug McNaught 2004-08-27 22:14:00 Re: Problem with sql COPY command