pgp encryption functions
От | Christian Petzold |
---|---|
Тема | pgp encryption functions |
Дата | |
Msg-id | 4AF5DA03.6060207@gmx.net обсуждение исходный текст |
Ответы |
Re: pgp encryption functions
Re: pgp encryption functions |
Список | pgsql-general |
Hello, I'm trying to use the pgp_pub_encrypt and pgp_pub_decrypt_bytea functions to store some data in my db. This is how I encrypt: INSERT INTO "Test"( "test") VALUES (pgp_pub_encrypt('test', dearmor('-----BEGIN PGP PUBLIC KEY BLOCK----- Version: GnuPG v2.0.12 (MingW32) mQENBErk2KkBCAC.... (public key block) ... -----END PGP PUBLIC KEY BLOCK----- '))); And this is how I try to decrypt: SELECT pgp_pub_decrypt_bytea(bytea ("test"), dearmor('-----BEGIN PGP PRIVATE KEY BLOCK----- Version: GnuPG v2.0.12 (MingW32) lQO+BErk2KkBC... (private key block) ... -----END PGP PRIVATE KEY BLOCK----- '), 'ktulu3437') --> this is the passphrase FROM "Test"; Encryptions works fine, but the decrypting returns "Corrupt data". What am I doing wrong? Christian Petzold.
В списке pgsql-general по дате отправления: