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 по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: slony issues.
Следующее
От: "Vlad Romascanu"
Дата:
Сообщение: Why the mismatch? {row size reported by VACUUM} vs. {table size on disk / number of rows} vs. {sum of column type sizes}