Problem with COPY command on pg_dump

From: Blake McBride <blake(at)mcbride(dot)name>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with COPY command on pg_dump
Date: 2017-12-09 15:42:03
Message-ID: CABwHSOvhnqZW1O5aHAZVd8OvhMC_UjhkWQQRcf9VYpbJ9Mr_7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

I am using pg_dump on version 9.5.10 and trying to import it on version
9.3.20. Many (or all) COPY commands are failing with messages like:

psql:16504.db:16874: ERROR: missing data for column "street"
CONTEXT: COPY address, line 1: ""

Is there an easy way for me to fix this (like export with some
compatibility flag)?

Thanks!

Blake McBride

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2017-12-09 15:53:58 Re: Problem with COPY command on pg_dump
Previous Message Stephen Frost 2017-12-08 15:16:15 Re: Secured ldap connectivity between PostgreSQL and LDAPs server