PQescapeString/copy problem. - Mailing list pgsql-hackers

From Kurt Roeckx
Subject PQescapeString/copy problem.
Date
Msg-id 20021230012336.GA11853@ping.be
Whole thread Raw
Responses Re: PQescapeString/copy problem.
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Kevin Brown
Date:
Subject: Re: MOVE strangeness
Next
From: Tom Lane
Date:
Subject: Re: PQescapeString/copy problem.