Re: [HACKERS] COPY from question

2004-02-04 Thread Slavisa Garic
Hi Kevin, On Tue, 3 Feb 2004, Kevin Brown wrote: Slavisa Garic wrote: Using pg module in python I am trying to run the COPY command to populate the large table. I am using this to replace the INSERT which takes about few hours to add 7 entries where copy takes minute and a half.

Re: [HACKERS] COPY from question

2004-02-03 Thread Tom Lane
Kevin Brown [EMAIL PROTECTED] writes: Slavisa Garic wrote: Using pg module in python I am trying to run the COPY command to populate the large table. I am using this to replace the INSERT which takes about few hours to add 7 entries where copy takes minute and a half. That difference in

Re: [HACKERS] COPY from question

2004-02-02 Thread Kris Jurka
On Tue, 3 Feb 2004, Slavisa Garic wrote: My understanding is that COPY workes FROM 'filename' or STDIN where the last characters are '.\\n'. I tried using the copy from 'filename' and as I said NetBSD is not complaining where I get the following error on Linux machine even if permissions on

Re: [HACKERS] COPY from question

2004-02-02 Thread Tom Lane
Slavisa Garic [EMAIL PROTECTED] writes: ... I get the following error on Linux machine even if permissions on the data file are 777: _pg.error: ERROR: COPY command, running in backend with effective uid 26, could not open file '/home/slavisa/.nimrod/experiments/demo/ejdata' for