On Wed, Nov 19, 2014 at 2:49 AM, VENKTESH GUTTEDAR <
venkteshguttedar(at)gmail(dot)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