On Tue, Mar 26, 2013 at 1:36 PM, Bill Moran <wmoran@xxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
