I see the problem now. It was my file parser that was escaping the value then passing it to PQescapeString which resulted in \\n instead of \n. Guess I was on a wild goose chase. I guess PQescapeString() and PQputline() are mutally exclusive ... my bad!
Thanks, Marc L. Tom Lane wrote: > Marc Lavergne <[EMAIL PROTECTED]> writes: > >>Just to give a little background, using pgdump in "default" mode creates >>a dump file that includes inline newlines and tabs. > > > How old a PG release are you using? COPY has quoted special characters > properly for a long time. > > regards, tom lane > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster