R: Re: quote string exactly as it is

From: "dario(dot)ber(at)libero(dot)it" <dario(dot)ber(at)libero(dot)it>
To: <mmoncure(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: R: Re: quote string exactly as it is
Date: 2009-12-02 13:57:43
Message-ID: 18259906.1455081259762263867.JavaMail.defaultUser@defaultHost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks a lot for replies! Dollar quote is what I needed, but I could find it
in!

Dario

>----Messaggio originale----
>Da: mmoncure(at)gmail(dot)com
>Data:
02/12/2009 14.15
>A: "dario(dot)ber(at)libero(dot)it"<dario(dot)ber(at)libero(dot)it>
>Cc: <pgsql-
general(at)postgresql(dot)org>
>Ogg: Re: [GENERAL] quote string exactly as it is
>
>On
Wed, Dec 2, 2009 at 7:10 AM, dario(dot)ber(at)libero(dot)it <dario(dot)ber(at)libero(dot)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
>
>dollar quote it:
>
>select $abc$ss\\\ss$abc$;

>
>merlin
>

Browse pgsql-general by date

  From Date Subject
Next Message Howard Cole 2009-12-02 13:59:32 Re: Unexpected EOF on client connection
Previous Message Kern Sibbald 2009-12-02 13:18:52 Catastrophic changes to PostgreSQL 8.4