[GENERAL] [general] Error while decrypting using pgp

2014-11-19 Thread VENKTESH GUTTEDAR
Hello, I am running postgresql 9.3.5 on Ubuntu14.04. i have the table two fields of varchar type. while inserting the data in the following way. INSERT INTO testusers(username, phone_no) SELECT pgp_sym_encrypt(test.username, keys.pubkey), pgp_sym_encrypt(test.phone_no,

Re: [GENERAL] [general] Error while decrypting using pgp

2014-11-19 Thread Jeff Janes
On Wed, Nov 19, 2014 at 2:49 AM, VENKTESH GUTTEDAR venkteshgutte...@gmail.com wrote: i am getting this error ERROR: function pgp_sym_decrypt(character varying, text) does not exist LINE 1: SELECT pgp_sym_decrypt(phone_no, keys.privkey), pgp_sym_decrypt(us... The encrypted