i could not found exact steps for using pgp_sym_encrypt() and pgp_sym_decrypt()

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