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

Re: Problem with sql COPY command

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Jon Asher" <jon(at)vagabond-software(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem with sql COPY command
Date: 2004-08-27 22:14:00
Message-ID: 873c28xm8n.fsf@asmodeus.mcnaught.org (view raw or flat)
Thread:
Lists: pgsql-general
"Jon Asher" <jon(at)vagabond-software(dot)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

In response to

pgsql-general by date

Next:From: Richard PooleDate: 2004-08-27 22:16:25
Subject: Re: Problem with sql COPY command
Previous:From: Thomas F.O'ConnellDate: 2004-08-27 22:09:24
Subject: Re: pg_autovacuum start-script

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