pgp encryption functions - Mailing list pgsql-general

From Christian Petzold
Subject pgp encryption functions
Date
Msg-id 4AF5DA03.6060207@gmx.net
Whole thread Raw
Responses Re: pgp encryption functions
Re: pgp encryption functions
List 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 by date:

Previous
From: Jeff Davis
Date:
Subject: Re: slony issues.
Next
From: "Vlad Romascanu"
Date:
Subject: Why the mismatch? {row size reported by VACUUM} vs. {table size on disk / number of rows} vs. {sum of column type sizes}