Re: Problem with COPY command on pg_dump - Mailing list pgsql-general

From Rob Sargent
Subject Re: Problem with COPY command on pg_dump
Date
Msg-id 93532B21-1F53-424D-954E-1096C2852C12@gmail.com
Whole thread Raw
In response to Problem with COPY command on pg_dump  (Blake McBride <blake@mcbride.name>)
Responses Re: Problem with COPY command on pg_dump
Re: Problem with COPY command on pg_dump
List pgsql-general

> On Dec 9, 2017, at 8:42 AM, Blake McBride <blake@mcbride.name> wrote:
>
> 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
failingwith 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

>
Is there in fact ‘street’ data in the file?   Sounds like you have the wrong number of columns. Do you have your actual
dumpand restore commands to show here? 



pgsql-general by date:

Previous
From: Blake McBride
Date:
Subject: Problem with COPY command on pg_dump
Next
From: Dale Seaburg
Date:
Subject: Windows XP to Win 10 migration issue