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.
The column that is being copy is a varchar. If the string that
is being copied is the size of the varchar, and the string
contains a ', I get an error that the string is too big for the
varchar.
PQescapeString() turns the ' into a '', which should work I
think, but doesn't.
I'm currently replacing the '' by a \' and that seems to work for
me.
Kurt