Skip to content

tms_drivers decrypt driver detail database cells

This query can be used to decrypt encrypted values in the database:

SELECT
    driver_company.org_uuid,
    driver.uuid,
    COALESCE(pgp_sym_decrypt(
        driver.details, '<DRIVER_DETAILS_ENCRYPTION_KEY>'
    )::jsonb, '{}'::jsonb)->>'phone_number' as phone_number
FROM driver
JOIN driver_company ON driver.index = driver_company.driver_index
WHERE driver_company.org_uuid = '<ORGANIZATION_UUID';