Re: Pg 9.1.3 pg_crypto question - Mailing list pgsql-general

Aaron Burnett <aburnett@bzzagent.com> writes:
> 9.1.3 is just not decrypting nor throwing errors.

> 9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'),
> decode('bcRJvbqeWMPDXMtIP8pPOQ==', 'base64'), '0000000000000000',
> 'aes-cbc');
>         decrypt_iv
> --------------------------
> \x48656c6c6f205468657265
> (1 row)

I think this is the same result, it's just being shown in hex.
See the bytea_output configuration parameter.

            regards, tom lane