Re: Unexpected behaviour of encode() - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Unexpected behaviour of encode()
Date
Msg-id CAHyXU0w3_2_os9LgEyZv+V=Owi6bSXKh+Yg7LUpnM8FEyTfHCg@mail.gmail.com
Whole thread Raw
In response to Re: Unexpected behaviour of encode()  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
On Tue, Mar 26, 2013 at 1:36 PM, Bill Moran <wmoran@potentialtech.com> wrote:
> I get "can't" which is what I'd expect.  I would then expect
> encode to escape the ' somehow.

nope -- encode/escape doesn't escape single quotes. it's not designed
to produce output that can be fed directly back into the database (at
least, not without escaping).  yes, it (escape format) is pretty
terrible.

merlin


pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Unexpected behaviour of encode()
Next
From: Tom Lane
Date:
Subject: Re: Unexpected behaviour of encode()