Re: [SQL] Question about COPY command - Mailing list pgsql-sql

From Christopher Sawtell
Subject Re: [SQL] Question about COPY command
Date
Msg-id 00012423512800.00577@berty
Whole thread Raw
In response to Question about COPY command  (Mercury He <mercury@penit.com>)
List pgsql-sql
On Mon, 24 Jan 2000, Mercury He wrote:
> I tried the import some text file to PostgreSQL database with COPY
> command.
> But I got this message:
> ERROR:  COPY command, running in backend with
> effective uid 100, could not open.
> 
> What's wrong with it?

Permissions on the text file prevent it being read by the backend process.
( uid100 ) Make it world readable.

--
Sincerely etc.,
NAME       Christopher Sawtell - Support Engineer - iOpen Technologies Ltd.CELL PHONE 021 257 4451ICQ UIN
45863470EMAIL     chris @ iopen . co . nz,  csawtell @ xtra . co . nzCNOTES
ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
---->>> Please refrain from using HTML attachments in e-mails to me. <<<----



pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] Duplicate tuples with unique index
Next
From: Kovacs Zoltan Sandor
Date:
Subject: dumping groups and users