Re: [GENERAL] pg_dump and insert json with copy - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] pg_dump and insert json with copy
Date
Msg-id 29521.1500646178@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] pg_dump and insert json with copy  (basti <mailinglist@unix-solution.de>)
List pgsql-general
basti <mailinglist@unix-solution.de> writes:
> some tables has json type and show the following error at restore time:

> ERROR:  syntax error at or near "a"
> LINE 1: a:1:{i:0;
>         ^

Is that really the very first error reported by the restore run?
It seems much more likely to be a failure cascading from something else.

In any case, you haven't provided nearly enough information for anyone
else to investigate this problem.  Please see
https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

            regards, tom lane


pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: [GENERAL] Schemas and foreign keys
Next
From: Albe Laurenz
Date:
Subject: Re: [GENERAL] Schemas and foreign keys