Re: [HACKERS] COPY x FROM STDIN escape handlers

2002-07-15 Thread Marc Lavergne
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

Re: [HACKERS] COPY x FROM STDIN escape handlers

2002-07-15 Thread Tom Lane
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. re

[HACKERS] COPY x FROM STDIN escape handlers

2002-07-15 Thread Marc Lavergne
Just to give a little background, using pgdump in "default" mode creates a dump file that includes inline newlines and tabs. The solution is to use the -Fc option but it's a little late for that if all one has is a "default" dump file. I was hoping to simply run a conversion on the file to cr