Kurt Roeckx <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
