ERROR: Corrupt ascii-armor

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.

Responses

Browse pgsql-general by date

  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