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: (view raw or whole 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

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-2015 The PostgreSQL Global Development Group