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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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