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 message needs to be binary data, bytea. You can cast it to bytea, like: pgp_sym_decrypt(phone_no::bytea, keys.privkey) But really the column phone_no should be of type bytea to start with. Cheers, Jeff
