Re: quote string exactly as it is - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: quote string exactly as it is
Date
Msg-id 2f4958ff0912020428g1130a314wa598a4dc97f828de@mail.gmail.com
Whole thread Raw
In response to quote string exactly as it is  ("dario.ber@libero.it" <dario.ber@libero.it>)
List pgsql-general


On Wed, Dec 2, 2009 at 12:10 PM, dario.ber@libero.it <dario.ber@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

pgsql-general by date:

Previous
From: "dario.ber@libero.it"
Date:
Subject: quote string exactly as it is
Next
From:
Date:
Subject: Auto Vacuum Daemon