ERROR: Corrupt ascii-armor

[VENKTESH GUTTEDAR <venkteshguttedar@xxxxxxxxx>]

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.