https://tech.uvoo.io/index.php?action=history&feed=atom&title=Pgp_postgres 2026-04-19T22:01:50Z Revision history for this page on the wiki MediaWiki 1.35.2 https://tech.uvoo.io/index.php?title=Pgp_postgres&diff=5100&oldid=prev 2024-03-18T04:24:23Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 04:24, 18 March 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">https://hardyantz.medium.com/data-encryption-in-postgresql-a4b51a60dfc2</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>```</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>```</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-- Assuming you have a public key named 'my_public_key' already imported into your keyring</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-- Assuming you have a public key named 'my_public_key' already imported into your keyring</div></td></tr> </table>

Busk https://tech.uvoo.io/index.php?title=Pgp_postgres&diff=5099&oldid=prev 2024-03-18T04:19:01Z

<p>Created page with &quot;``` -- Assuming you have a public key named &#039;my_public_key&#039; already imported into your keyring -- Encrypting a message SELECT pgp_pub_encrypt( &#039;Your secret message here&#039;,...&quot;</p> <p><b>New page</b></p><div>```<br /> -- Assuming you have a public key named 'my_public_key' already imported into your keyring<br /> <br /> -- Encrypting a message<br /> SELECT pgp_pub_encrypt(<br /> 'Your secret message here',<br /> keys.keydata<br /> ) AS encrypted_message<br /> FROM (<br /> SELECT pgp_pub_decrypt(key, 'my_secret_passphrase') AS keydata<br /> FROM pgp_keys<br /> WHERE key_id = 'my_public_key'<br /> ) AS keys;<br /> ```</div>

Busk