"Mason Hale" <masonhale@gmail.com> writes:
> I'm having a problem loading a recent pg_dump of our production database.
> However, when trying to load the file for this month's snapshot, we are (for
> the first time) seeing a slew of errors, such as:
> invalid command \N
> invalid command \N
> ERROR: syntax error at or near ""/>\n <img alt="" style="" at character 1
> LINE 1: "/>\n <img alt="" style="border: 0;
> ^
You need to look at the very first error, and ignore the slew following
it. What seems to have happened here is that an error in the COPY command
caused psql to fall out of copy mode (or perhaps never enter it in the
first place) and start trying to treat lines of COPY data as SQL
commands. So, tons of noise. What was the first error?
regards, tom lane