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

Re: COPY command cannot access file...

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Alan T(dot) Miller" <amiller(at)hollywood101(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: COPY command cannot access file...
Date: 2004-01-29 13:14:17
Message-ID: 20040129131417.GD17068@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, Jan 29, 2004 at 05:17:23 -0700,
  "Alan T. Miller" <amiller(at)hollywood101(dot)com> wrote:
> I understand why this is happening. The database server, does not seem to be
> able to access the file and from what I understand changing permissions of
> the file will not help. What I need to know is how can I give the database
> server permission to read such files? I have a number of scripts written
> this way that import millions of records. I read somewhere I should use the
> 'psql \copy' command instead. But then the manual page for the psql command
> reccomends the SQL copy command for large numbers of records, and I would
> hate to have to rewrite so many scripts to change it. With that, how can I
> grant the database server what it needs to read these files.

Normally you want to have the copy command read from standard input
and then the application can read from the file and write to the
connection.

In response to

pgsql-novice by date

Next:From: George WeaverDate: 2004-01-29 13:28:47
Subject: Re: Setting date and time
Previous:From: HKDate: 2004-01-29 12:39:11
Subject: Re: COPY command cannot access file...

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