"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