Re: quote string exactly as it is

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: "dario(dot)ber(at)libero(dot)it" <dario(dot)ber(at)libero(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: quote string exactly as it is
Date: 2009-12-02 13:15:17
Message-ID: b42b73150912020515l197c7e59m3287b673334f4e52@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kern Sibbald 2009-12-02 13:18:52 Catastrophic changes to PostgreSQL 8.4
Previous Message A.Bhattacharya 2009-12-02 12:46:24 Auto Vacuum Daemon