encryption of specific columns

From: Matthias Apitz <guru(at)unixarea(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: encryption of specific columns
Date: 2019-06-24 14:10:01
Message-ID: 20190624141001.GA3000@c720-r349041
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)unixarea(dot)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!

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Brannen 2019-06-24 17:27:48 RE: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems
Previous Message Achilleas Mantzios 2019-06-24 11:30:17 Re: got stuck in pglogical upgrade on FreeBSD