On 10/10/2011 04:37 PM, tushar nehete wrote:
Hi,
i could not found exact steps for using pgp_sym_encrypt() and pgp_sym_decrypt().
I want to encrypt the data of column and
then in a function decrypt that column using pgp_sym_encrypt()
and pgp_sym_decrypt() functions.
Its working fine with postgres 8.4 eg: select
pgp_sym_encrypt('tushar','22');
Version of postgres is 9.0
If it was working for you in 8.4 and isn't working in 9.0, what
changed?
Are you using exactly the same arguments to the function in both
tests?
What is the error message?
Have you installed the pgcrypto contrib module in your 9.0
database(s)?
--
Craig Ringer
|
