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.
