Re: Pg 9.1.3 pg_crypto question

Thanks, Tom. That was exactly it.

Best Regards

On 4/10/12 2:50 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

>Aaron Burnett <aburnett(at)bzzagent(dot)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