Re: bytea and character encoding when inserting escaped literals

[Tom Lane <tgl@xxxxxxxxxxxxx>]

Lee Feigenbaum <lee@xxxxxxxxxxxxxxx> 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