Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL: Copy from File missing data error - Mailing list pgsql-general

From Dimitri Maziuk
Subject Re: PostgreSQL: Copy from File missing data error
Date
Msg-id 062af97a-16c4-b9ed-73e6-3e22ec54b967@bmrb.wisc.edu
Whole thread Raw
In response to PostgreSQL: Copy from File missing data error  (Holly Gibons <holyg1986@gmail.com>)
List pgsql-general
Tree view 
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
Attachment

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: PostgreSQL: Copy from File missing data error
Next
From: Alessandro Gherardi
Date:
Subject: scram-sha-256 authentication broken in FIPS mode