Re: pgcrypto - real life examples to encrypt / decrypt - Mailing list pgsql-general

On Mon, Aug 2, 2021 at 11:14 PM Vikas Sharma <shavikas@gmail.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