Re: escape

"Jean-Yves F. Barbier" <12ukwn@gmail.com> writes:
> But I also would like to know if there is another way to escape my string

No --- PG has too many string quoting conventions already; we aren't
likely to add more.

What you should be looking for is a way for your code to avoid dealing
directly with the quoting rules.  You might be able to use out-of-line
parameter values, or use a subroutine provided by your PG client library
to convert the string into properly quoted form.  You haven't said what
client-side programming environment you're using so it's hard to be more
specific than that.

            regards, tom lane