I am working with a PostgreSQL database and need to encrypt sensitive data fields (like SSN and email) for security purposes. However, I want to be able to query these encrypted fields efficiently, especially using WHERE clauses, without decrypting each…
Trying to use the pgcrypto extension for PostgreSQL but getting this undefined symbol: EVP_cast5_cbc whenever I try to start the server: [postgres@localhost ~]$ pg_ctl start -D /usr/local/pgsql/data waiting for server to start....2024-04-26 10:39:15.326 CEST [3036]: db=,user=,app=,client= LOG: 00000: pgaudit extension…
I want to prepend a string to the uuid generated by PostgreSQL's gen_random_uuid() to use as the uuid for one of my models (it won't be the primary key). Think like Stripe's price and customer ids - "price_xxxx..." and "cus_xxxx..."…
I'm working on a module where I'm evaluating method to add thumbprint (x5t#256) value to all public keys present in the DB. Conversion using javascript libraries, java libraries is doable. however trying to convert the same using pgcrypto doesn't seem…