Re: postgresql, odbc and escape characters?

Kristian Rink wrote:
> For what I understood (and what sounds logical to me, looking at
> those things are handled in unix environments), the \' in "escape
> '\'" is parsed as an escaped ' char, so in the end the query fails
> because of a missing string termination.
>
> Question: Is there any way to modify the behavior of postgresql
> server itself or of the odbc driver to deal with things like that?

No.  Just pick a different escape character or double the backslash.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/