From: | VENKTESH GUTTEDAR <venkteshguttedar(at)gmail(dot)com> |
---|---|
To: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | ERROR: Corrupt ascii-armor |
Date: | 2014-11-17 11:00:32 |
Message-ID: | CA+iwz4=n5ZOz0mbigycbTxvMu7TXs8JheNjsOud0FA0HkBkRuA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I am running PostgreSQL 9.3.5 on Ubuntu 14.04. i want to encrpty data
while storing and decrypt while retrieving it. so i am using pgcrypto to
achieve it. i have genrated the keys using gpg --gen-key.
and i have exported them to also.
I have created the table this way :
CREATE TABLE testuserscards(card_id SERIAL PRIMARY KEY, username
varchar(100), cc bytea);
and when i am trying to insert data :
INSERT INTO testuserscards(username, cc)SELECT robotccs.username,
pgp_pub_encrypt(robotccs.cc, keys.pubkey) As cc
FROM (VALUES ('robby', '41111111111111111'),
('artoo', '41111111111111112') ) As robotccs(username, cc)
CROSS JOIN (SELECT dearmor('-----BEGIN PGP PUBLIC KEY BLOCK-----
super publickey goobly gook goes here
-----END PGP PUBLIC KEY BLOCK-----') As pubkey) As keys;
i am getting the error as ERROR: Corrupt ascii-armor.
please help me to encrypt data..
or is there any other way to achieve safe encryption and decryption.?
--
Regards :
Venktesh Guttedar.
From | Date | Subject | |
---|---|---|---|
Next Message | VENKTESH GUTTEDAR | 2014-11-17 11:23:43 | [general] Encrypting/Decryption |
Previous Message | Dmitriy Igrishin | 2014-11-17 09:24:58 | Re: documentation for lo_* functions |