Re: quote string exactly as it is

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: quote string exactly as it is
Дата
Msg-id 2f4958ff0912020428g1130a314wa598a4dc97f828de@mail.gmail.com
обсуждение исходный текст
Ответ на quote string exactly as it is  ("dario.ber@libero.it" <dario.ber@libero.it>)
Список 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 по дате отправления:

Предыдущее
От: "dario.ber@libero.it"
Дата:
Сообщение: quote string exactly as it is
Следующее
От:
Дата:
Сообщение: Auto Vacuum Daemon