Re: Problem with sql COPY command - FIXED

Thanks to all...  it's importing now.  I'm still learning Linux after
upgrading from Windows.  Moving the file to another dir (\tmp) did it.   Jon

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Richard Poole
Sent: Friday, August 27, 2004 3:16 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings