As an administrator for your organization, you may decrypt data to assess user engagement.
To decrypt data, you must enable and verify the pgcrypto extension. For more information, refer to Enabling pgcrypto extension.
NOTE: You must replace the following in the example code snippet:
‘BEGIN PGP MESSAGE-----END PGP MESSAGE’with your encrypted PGP key from line 5 to 12.‘BEGIN PGP PRIVATE KEY BLOCK-----END PGP PRIVATE KEY BLOCK’with your Private key from line 17 to 26.'passphrase'with the passphrase used to generate the key pair in line 29.
The encrypted key can be retrieved from the database by querying any table, as shown in line 5 to 12.
Enter the following details in your PostgreSQL database:
SELECT pgp_pub_decrypt( dearmor('-----BEGIN PGP MESSAGE----- Version: BCPG v1.80 wcBMAyF7uBeJzcrrAQgAg6pic7+vt2Nr2b+X3IOLXk4i9kbF+iKJXkNkz9QMQ6K3 OQ3XE2huVPB5JNjuwB0EaC5j3ZIG8AfRqnvE8FkR/EGaBm31yI71OERIFNIJajpX DGuVyJUYgZWxFBaITyR7QKpJFcGUGB9AnlKR9rShhPYNe+jXFRVOIJrG2Ye01XVo qXbmSGB5TMNbBJQkxuz3nmCPKUQU+uJ2o4lv1HrRK1MM4d0rfklZYUrsM5hbGu3x dtCN+AbeuM2XsB2rQDBILQ4wsfx5xHms7rwxW+iHSfTXUqLLCjd/YyBbpTZYUGkL dpiR4lrhU8Q9OJ8plcmIzqsxTtCa9DHiFHmGghx5fdI9AV6O0mnGqV9ahzJb2qlf y1mSVTBJ2dXciZG2kkiXiqU0XeSgKO2ex+E/uVuFJAZDB3L5OF0UwEaiNHjphA== =Qqwq -----END PGP MESSAGE----- '), dearmor('-----BEGIN PGP PRIVATE KEY BLOCK----- lQPGBGg4erIBCACr1bkrlYehO2hqWF8OrDEoO+CD71mkKIYYQS++whBES1QC1pUH b+YY5acKyh08MO/lQtYnMZuM7aJ+D7B/LBensyp9mp59+ALnPIUrKP9D99lcd24y 6BA1prb2o9GaM7gKMRs26UxnTBFgRisjQ7kUYAkn3l4e/NmCSgYbOxS5TLxykk7y VZQJCJBfRPTQEw4IZW7+wM3Z95Gk5+NAXW4wj+TAGdB1I3qX1HhvUatqTU /fbssJDAsxhcGJinGdw21PXuXqcUiJ9KUYaPOawZ0PEH0lEz8vgEejT8oZIn+ICh rBMeHCCpXZx56xULhk6eoMSZRTQOS+kGi/3G8N/BksaPdXHD3xVtHpNh4REsUjYN /Moy0/2zn0BL2diPnVKgISZvBkI4GXw5asvqquk+KkVOSF+32wNdKZlMyeb1LCcr xuAFPlODHkj4MsgA9fiwk6VNZ3lLEH9Admk3Aor9MfsJf01idsY5UK90SoOpSU38 0MrYFcIjXK11F2jL/GIta4vj+ao= =nxIB -----END PGP PRIVATE KEY BLOCK----- '), 'passphrase' ) AS decrypted_text;For more information, refer to pgcrypto-cryptographic functions.