Postgres Pro
Downloads
Home   >   mailing lists

i could not found exact steps for using pgp_sym_encrypt() and pgp_sym_decrypt() - Mailing list pgsql-general

From tushar nehete
Subject i could not found exact steps for using pgp_sym_encrypt() and pgp_sym_decrypt()
Date
Msg-id CANuBLQVSwEuafsEY1nfAo4nFV-9+cLtcMJMy2SW7Lb5g-K95rA@mail.gmail.com
Whole thread Raw
Responses Re: i could not found exact steps for using pgp_sym_encrypt() and pgp_sym_decrypt()  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: Permission for pg_shadow.
Next
From: Frank Lanitz
Date:
Subject: Re: Postgres 8.4: archive_timeout vs. checkpoint_timeout