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

From Doug McNaught
Subject Re: Problem with sql COPY command
Date
Msg-id 873c28xm8n.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Problem with sql COPY command  ("Jon Asher" <jon@vagabond-software.com>)
List pgsql-general
"Jon Asher" <jon@vagabond-software.com> writes:

>    A comma delimited text file has been placed in a local directory with
>    permissions set to allow any user to read or write to it:
>    /root/Desktop/server_transfer/WorldPoints_v2.txt'

The '/root' directory is often not world-readable.  Try putting the
file under '/tmp' or '/var/tmp', and remember that the file will be
read as the "postgres" user (or whatever your database server runs
as).

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: pg_autovacuum start-script
Next
From: Richard Poole
Date:
Subject: Re: Problem with sql COPY command