Re: Problem with encode () and hmac() in pgcrypto

On Wed, Feb 2, 2011 at 1:19 AM, hlcborg <h.luis.cardoso@gmail.com> wrote:
>> These two operations are not equivalent.
>
> But...
> Can I have this operation done in the Stored Procedure inside the Database?
> Plain SHA1, which is signed with RSA signature. and in the end encoded to
> base64?
>
> I was looking in the pgcrypto functions, and I haven´t found any that I
> could use.... I think... Maybe I am not looking for the rigth one.
> I need to use Plain SHA1 signed with a RSA signature and encoded into base64
> due to a new law related to digital signature in invoices in my country.

pgcrypto does not do signing, sorry.

But you can do it with PL/Python or PL/Perl and their wrapper libraries
around OpenSSL (or any other crypto library).

--
marko