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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general