quote string exactly as it is

Поиск
Список
Период
Сортировка
От dario.ber@libero.it
Тема quote string exactly as it is
Дата
Msg-id 7596511.1443121259755813170.JavaMail.defaultUser@defaultHost
обсуждение исходный текст
Ответы Re: quote string exactly as it is  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Re: quote string exactly as it is  (Merlin Moncure <mmoncure@gmail.com>)
Re: quote string exactly as it is  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Re: quote string exactly as it is  (Bill Todd <pg@dbginc.com>)
Список pgsql-general
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!


What I want to do is to pass a string to a custom made function. Since the
string can contain various metacharcters I need some way to pass this string
exactly as it is.

(For those who might be interested, the strings I'm working
with are FASTQ quality scores)

I'm using Postgresql 8.3 on Windows XP

Thanks
a lot!


Dario

В списке pgsql-general по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Storing images in database for web applications
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: quote string exactly as it is