On Wed, Dec 2, 2009 at 12:10 PM, dario....@libero.it <dario....@libero.it>wrote:
> Hello,
>
> How can I quote a string *exactly* as it is? I tried using
> quote_literal() but it doesn't return what I need in some cases.
>
> E.g.
>
> If my
> string is: ss\\\ss
>
> And I do:
>
> select quote_literal('ss\\\ss');
>
> I get:
>
>
> E'ss\\ss' <-- My string now has E'' added and one backslash has been
> removed!
>
http://www.postgresql.org/docs/8.3/static/sql-syntax-lexical.html
That E tells postgres, that string is escaped.
--
GJ
