Re: [GENERAL] pg_dump and insert json with copy

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