When an column is encrypted you can't index the cleartext since it undermine the encryption and if you encrypt it in the application then postgres never had the

When an column is encrypted you can't index the cleartext since it undermine the encryption and if you encrypt it in the application then postgres never had the cleartext. Pgcrypto encrypts at an higher level than the indexer operates, so it sees only the encrypted data.