On 9/30/23 07:01, pf@pfortin.com wrote:
> Hi Adrian,On Fri, 29 Sep 2023 14:27:48 -0700 Adrian Klaver wrote:
>
>> On 9/29/23 1:37 PM, pf@pfortin.com wrote:
>>> Hi,
>> I'm going to say it is the
>>
>> ( -- import only a subset of columns
>>
>> I suspect the -- comment is the issue.
>
> I wish it was that easy. It's not in the code; I added that as a
> clarification within the email only.
>
>> You need to show the actual Python code for a more complete answer.
>
> Attached...
>
> Source file (44,530 records):
> https://s3.amazonaws.com/dl.ncsbe.gov/data/ncvoter53.zip
> Attached is a 10 row (incl. header) sample file.
I am not seeing the sample file.
>
> $ dbcopy_voter2 /tmp/ncvoter53_10.txt test ncv53 <db_password>
Not sure what the above is supposed to be doing?
What I was looking for is the Python code snippet where you actually run
the COPY.
Also per Tom's post information on whether there are extensions
installed or if there is an event trigger running?
>
>
>>> f1, f3, f5 ) FROM '/tmp/foo.txt'
--
Adrian Klaver
adrian.klaver@aklaver.com