On May 2, 2006, at 10:07 AM, tony wrote:
> Reading through in a text editor (nedit) rather than with pico or nano
> in a terminal the sql colour coding gives me a clue:
>
> - the data contains non escaped ' as in "d'Anjou"
>
> Is this my issue?
Again, you have not posted exactly what the error is. Show the
commands you used to dump and restore and include the exact error
output from the restore operation.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL