encryption of specific columns - Mailing list pgsql-general

From Matthias Apitz
Subject encryption of specific columns
Date
Msg-id 20190624141001.GA3000@c720-r349041
Whole thread Raw
List pgsql-general
Hello,

I've read the 10.x handbook, chapter 18.8. about the various encryption
options. One question remains: If I encrypt a column, for example the
birthdate of PII data, is this still searchable with

SELECT * FROM table WHERE birthdate = 07.12.1955;

Thanks

    matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
May, 9: Спаси́бо освободители! Thank you very much, Russian liberators!



pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: got stuck in pglogical upgrade on FreeBSD
Next
From: Kevin Brannen
Date:
Subject: RE: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and HavingProblems