Re: bytea and character encoding when inserting escaped literals

Lee Feigenbaum <lee@thefigtrees.net> writes:
> Would be nice if the bytea parser understood hex representation too, but
> beggars can't be choosers :)

decode() might help you:

select decode('1200AB', 'hex');
    decode
--------------
 \022\000\253
(1 row)

            regards, tom lane