On Wed, Feb 2, 2011 at 1:19 AM, hlcborg <h.luis.cardoso@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general