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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
