Richard Huxton <dev(at)archonet(dot)com> writes:
> Mario Splivalo wrote:
>> That's true, but I'd still like to use hexadecimal notation.
You could use decode():
regression=# select decode('c5a4', 'hex');
decode
----------
\305\244
(1 row)
regards, tom lane