Re: Restoring pg_dump Backup with psql Fails

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au> writes:
> But I get a whole bunch of errors, for example:
> <snip>
> ERROR:  syntax error at or near "all"
> LINE 1: all orders over $400.00 - freight free Order 10 of any produ...
>         ^

Please show us the *first* few errors, not some randomly chosen ones.
The above looks like a COPY has failed and psql has started thinking
that copy-data lines are commands, but how or why that happened is
not in evidence.

			regards, tom lane