Re: Playing with pgcrypto - Mailing list pgsql-general

From howardnews@selestial.com
Subject Re: Playing with pgcrypto
Date
Msg-id 17ab80acead0fc76246e112f956ade7e@selestial.com
Whole thread Raw
In response to Re: Playing with pgcrypto  (Erik Wienhold <ewie@ewie.name>)
List 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!



pgsql-general by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: Playing with pgcrypto
Next
From: gzh
Date:
Subject: Re:Re: Different execution plan between PostgreSQL 8.4 and 12.11