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

From: tushar nehete <tpnehete(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: i could not found exact steps for using pgp_sym_encrypt() and pgp_sym_decrypt()
Date: 2011-10-10 08:37:03
Message-ID: CANuBLQVSwEuafsEY1nfAo4nFV-9+cLtcMJMy2SW7Lb5g-K95rA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Lanitz 2011-10-10 08:51:26 Re: Postgres 8.4: archive_timeout vs. checkpoint_timeout
Previous Message AI Rumman 2011-10-10 08:30:48 Permission for pg_shadow.