Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Tino WildenhainDate: 2004-08-27 22:50:32
Subject: Re: Problem with sql COPY command
Previous:From: Doug McNaughtDate: 2004-08-27 22:14:00
Subject: Re: Problem with sql COPY command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group