[GENERAL] ERROR: Corrupt ascii-armor

2014-11-17 Thread VENKTESH GUTTEDAR
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

Re: [GENERAL] ERROR: Corrupt ascii-armor

2014-11-17 Thread Jeff Janes
On Mon, Nov 17, 2014 at 3:00 AM, VENKTESH GUTTEDAR venkteshgutte...@gmail.com wrote: INSERT INTO testuserscards(username, cc)SELECT robotccs.username, pgp_pub_encrypt(robotccs.cc, keys.pubkey) As cc FROM (VALUES ('robby', '4'), ('artoo', '41112') ) As