pg_dump errors

I have just spent some time frustrated with a pg_dump problem. My goal was
simply to copy data from two 7.0.3 tables to a new 7.1.2 database. The
symptom was a (nearly) endless series of "invalid command \N" error
messages when trying to "restore" into the new database.

I could find maybe a dozen or so references on Google, and none of them
seemed to give me the information I needed to solve this problem.
Finally, I ran across one message suggesting that using the "-d" option
("Dump data as proper insert strings") with pg_dump would avoid the
errors. Sure enough, it works.

The "PostgreSQL User's Guide" does list the "-d" option for pg_dump, but I
don't see how one would find out that this is the solution to the "invalid
command \N" problem. Perhaps this would be an appropriate addition to the
FAQ?

Thanks,

-Richard

-------------------------------------------
Richard Hodges | Matriplex, inc.
Product Manager | 769 Basque Way
rh(at)matriplex(dot)com | Carson City, NV 89706
775-886-6477 | www.matriplex.com