Re: PostgreSQL: Copy from File missing data error

2018-09-04 Thread Dimitri Maziuk
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 wi

Re: PostgreSQL: Copy from File missing data error

2018-09-04 Thread Ron
You might want to try pg_bulkload, and have it kick out malformed rows. It's packaged for RHEL6 and above, plus various other distros. On 09/04/2018 01:13 PM, Holly Gibons wrote: I'm using PostgreSQL 9.0 via pgAdmin III I'm trying to build a PostgreSQL/PostGIS database using Entire country fi