| From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
|---|---|
| To: | Vikas Sharma <shavikas(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: pgcrypto - real life examples to encrypt / decrypt |
| Date: | 2021-08-03 10:02:55 |
| Message-ID: | CAKoxK+6D9yntPX5_MDnAAKZnMnKfFti-p7TVj_7pCGox8bJn7Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Aug 2, 2021 at 11:14 PM Vikas Sharma <shavikas(at)gmail(dot)com> wrote:
>
> Dear Experts,
>
> Could you please share some real life examples of using pgcrypto in production?
>
> I am planning to use it in our environment and wondering what could be the best practice for its use.
It is not clear what you are going to do and which kind of encryption
you are going to use.
For a symmetric encryption this could be a starting point:
UPDATE secret
SET secret_text = pgp_sym_encrypt( clear_text,
'A-Strong-Secret-Password' );
I do remember there was an extension made to overtake pgcrypto, but
currently I don't remember the name.
Luca
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luca Ferrari | 2021-08-03 10:06:05 | Re: Unexpected block ID found when reading data |
| Previous Message | Vikas Sharma | 2021-08-03 08:21:10 | Re: pgcrypto - real life examples to encrypt / decrypt |