Re: PostgreSQL: Copy from File missing data error

From: Dimitri Maziuk <dmaziuk(at)bmrb(dot)wisc(dot)edu>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL: Copy from File missing data error
Date: 2018-09-04 18:46:06
Message-ID: 062af97a-16c4-b9ed-73e6-3e22ec54b967@bmrb.wisc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/04/2018 01:13 PM, Holly Gibons wrote:

> Could someone suggest what I'm doing wrong?

There's probably a magic character that is not escaped properly
somewhere before the error location. Exactly how to find them all in a
2GB+ file is another question: e.g. if you know python you could play
with csv.Reader and unicode/bytes encode/decode...

--
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alessandro Gherardi 2018-09-05 03:29:31 scram-sha-256 authentication broken in FIPS mode
Previous Message Ron 2018-09-04 18:26:00 Re: PostgreSQL: Copy from File missing data error