Re: Playing with pgcrypto

From: howardnews(at)selestial(dot)com
To: Erik Wienhold <ewie(at)ewie(dot)name>
Cc: Pgsql General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Playing with pgcrypto
Date: 2022-10-10 23:17:45
Message-ID: 17ab80acead0fc76246e112f956ade7e@selestial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> pgp_sym_encrypt uses a random salt each time, so you cannot compare the
> output
> to p1 like you would do with crypt to verify a given plaintext.
> Instead, use
> pgp_sym_decrypt with p1 as input to get the plaintext.
>
> --
> Erik

Ah! That makes sense. Thanks Erik!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message gzh 2022-10-11 03:12:55 Re:Re: Different execution plan between PostgreSQL 8.4 and 12.11
Previous Message Erik Wienhold 2022-10-10 22:52:27 Re: Playing with pgcrypto