On Wed, Nov 19, 2014 at 2:49 AM, VENKTESH GUTTEDAR <venkteshguttedar@xxxxxxxxx> 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
