Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
tushar nehete
Date:
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


Regards,
Tushar

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

From
Craig Ringer
Date:
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