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 r

[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 t