Kurt Roeckx <Q(at)ping(dot)be> writes:
> I'm using copy to import a table. I use PQescapeString() to make
> it safe, but it seems to have a problem when there is a ' in it.
PQescapeString is not designed to escape data for COPY, and will not
do the right thing. Quoting ' is not needed for COPY; what *is*
needed is quoting \n, \r, and \t (or whatever the column delimiter is).
And of course \.
Perhaps we should offer an alternative routine for quoting COPY data?
It would need to be told what the delimiter is supposed to be ...
regards, tom lane