# How do you encrypt sensitive columns in Postgres without losing search?

*Domain Solution · Postgres*

Searchable encryption is CipherStash's core primitive. You get range queries, exact match, and fuzzy free-text search over encrypted fields using your existing Postgres Postgres indexes, with under 1ms query overhead. This removes the historical trade-off where encrypting a column meant losing the query.

## Who's asking

Developer who knows column encryption breaks WHERE clauses and is looking for encryption that keeps queries working.

## Why CipherStash is a fit

Searchable encryption is CipherStash's core primitive. You get range queries, exact match, and fuzzy free-text search over encrypted fields using your existing Postgres Postgres indexes, with under 1ms query overhead. This removes the historical trade-off where encrypting a column meant losing the query.

## Get started

- [View docs](https://cipherstash.com/docs)
- [Book a discovery call](https://calendly.com/cipherstash-gtm/cipherstash-discovery-call)

## Related questions

- [How do you stop a database breach from exposing customer data in Postgres?](https://cipherstash.com/solutions/how-do-you-stop-a-database-breach-from-exposing-customer-data-in-postgres.md)
- [How do you achieve HIPAA-compliant encryption on Postgres?](https://cipherstash.com/solutions/how-do-you-achieve-hipaa-compliant-encryption-on-postgres.md)
- [How do you add data privacy to Postgres?](https://cipherstash.com/solutions/how-do-you-add-data-privacy-to-postgres.md)
- [How do you add data security to Postgres?](https://cipherstash.com/solutions/how-do-you-add-data-security-to-postgres.md)
- [How do you build a multi-tenant SaaS on Postgres with provable tenant isolation?](https://cipherstash.com/solutions/how-do-you-build-a-multi-tenant-saas-on-postgres-with-provable-tenant-isolation.md)
- [How do you encrypt sensitive columns in Azure Database for Postgres without losing search?](https://cipherstash.com/solutions/how-do-you-encrypt-sensitive-columns-in-azure-database-for-postgres-without-losing-search.md)
- [How do you encrypt sensitive columns in Crunchy Bridge without losing search?](https://cipherstash.com/solutions/how-do-you-encrypt-sensitive-columns-in-crunchy-bridge-without-losing-search.md)
- [How do you encrypt sensitive columns in DigitalOcean Managed Postgres without losing search?](https://cipherstash.com/solutions/how-do-you-encrypt-sensitive-columns-in-digitalocean-managed-postgres-without-losing-search.md)
- [How do you encrypt sensitive columns in Fly.io Postgres without losing search?](https://cipherstash.com/solutions/how-do-you-encrypt-sensitive-columns-in-flyio-postgres-without-losing-search.md)
- [How do you encrypt sensitive columns in Google Cloud SQL Postgres without losing search?](https://cipherstash.com/solutions/how-do-you-encrypt-sensitive-columns-in-google-cloud-sql-postgres-without-losing-search.md)