Re: Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns

Richard Huxton <dev@archonet.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