1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
| INSERT INTO testuserscards(username, cc)
SELECT robotccs.username, pgp_pub_encrypt(robotccs.cc, keys.pubkey) As cc
FROM (VALUES ('robby', '41111111111111111'),
('artoo', '41111111111111112') ) As robotccs(username, cc)
CROSS JOIN (SELECT dearmor('-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v2
mQGiBFbcFMURBADEatXuhWS8/by6vzgYISDNGNodSANSdH+yagbR1mtain+huOYf
nguswvrgJCU4QYRc/P3Q0EwMnuzLsLs/EFaOP5PKnJT+HY7N7vCSLltT5kL0Ff3r
j0XaEZ2Z0UlpCy+n08PRP1hi5swyL6bnsMToJMWlJhvTOb5ZSHGnTq8lYwCgi5ce
Go6FmQu7aIwpb2/WqtEmPcsD/jNsSu1OiD+st4q6qWHlAxIJPE/GVosQVLwWnoEI
EefYEpc5dQ+T7CuUp+uoZmL0asvQuePyy5eGJBTi8JlpAd7f7rvDG/nzeTQjynHT
QtntFxt1UwlK8LZ2APEAAMQWk5+CefHnYCfyXwC3y4UrqzppLk2oQHbtLUd9oz1Y
AOCXBACVk9+f8fYWy3qrCdXON9Wdoj16Sg0atwt6VlmVk+1cOh/11VxZfgpnJtYu
IhPLtl6q0fiUJNrKbl9BIsswzii/Y4isV0wC+YA01JrXZTf5VBt05ZxhHG9v5YRq
Z3bPnpnqT7JI4axzeVOwK6F8slxuSKztlrKKBmp+TO9/+utPtbQib3Blbm1vdGlv
biA8Z2NvYmVydEBvcGVubW90aW9uLmZyPohhBBMRAgAhBQJW3BTFAhsDBQsJCAcC
BhUICQoLAgQWAgMBAh4BAheAAAoJEGm+/UZRQ3L2ZFcAnjVf3AzZyhXx2/Dgg/v6
Ijnvkfg3AJ9N2px1ALiy05lg3DsYkUcqg/7yqLkBDQRW3BTFEAQA1NEdYg3siUS4
4f6qEasHMdwfMHFYizQwBUrLP5Bq5oJkLOA7zQo6HuVPExCg/ArSuKrjT4mTwPZU
AqFABAuGXquqbMKCb7G+yDp/FZMRldU5P5uQXs4ewkNqR/SSIDvLMLJQ+FChLhMW
q+mbA+6xLgVOM+vXswXSXBxkubSbMXsAAwUEAKTaGNlY4VzdgBSzK86fE/9ZHVw6
OpFg2iPmGSL1XUf3MSPB3HXnCKKJHe/WexOPbFTNcrViRkHu8p0uJvMTvWV/BN2w
5VP4Ja2i1TBhbO7WwyE6++7lt3IQHZnB03os/waNkEDI8cRlZzA5osGUiQJGK+ED
vRJcW9mBekzq36H9iEkEGBECAAkFAlbcFMUCGwwACgkQab79RlFDcvYheACeKFXg
h4YXfSJ432l4NjJ4TtNgrYcAn1qzP46YQQLCpq+nKYVC/EQREI+b
=irf1
-----END PGP PUBLIC KEY BLOCK-----') As pubkey) As keys;
pgp_pub_decrypt( pgp_pub_encrypt( 'secret', dearmor(pubkey) ),
dearmor(privkey) )
SELECT username, pgp_pub_decrypt(cc, keys.privkey) As ccdecrypt
FROM testuserscards
CROSS JOIN
(SELECT dearmor('-----BEGIN PGP PRIVATE KEY BLOCK-----
Version: GnuPG v2
lQHpBFbcFMURBADEatXuhWS8/by6vzgYISDNGNodSANSdH+yagbR1mtain+huOYf
nguswvrgJCU4QYRc/P3Q0EwMnuzLsLs/EFaOP5PKnJT+HY7N7vCSLltT5kL0Ff3r
j0XaEZ2Z0UlpCy+n08PRP1hi5swyL6bnsMToJMWlJhvTOb5ZSHGnTq8lYwCgi5ce
Go6FmQu7aIwpb2/WqtEmPcsD/jNsSu1OiD+st4q6qWHlAxIJPE/GVosQVLwWnoEI
EefYEpc5dQ+T7CuUp+uoZmL0asvQuePyy5eGJBTi8JlpAd7f7rvDG/nzeTQjynHT
QtntFxt1UwlK8LZ2APEAAMQWk5+CefHnYCfyXwC3y4UrqzppLk2oQHbtLUd9oz1Y
AOCXBACVk9+f8fYWy3qrCdXON9Wdoj16Sg0atwt6VlmVk+1cOh/11VxZfgpnJtYu
IhPLtl6q0fiUJNrKbl9BIsswzii/Y4isV0wC+YA01JrXZTf5VBt05ZxhHG9v5YRq
Z3bPnpnqT7JI4axzeVOwK6F8slxuSKztlrKKBmp+TO9/+utPtf4HAwIeaMem8q23
yukFoeXsT7w1zP8ceBSQtSWjJjISYFJKUgHNYDXyvL1h2ipnwEpmMZkGBKIXpz7C
S2yvs/d/HNp2D71ZtCJvcGVubW90aW9uIDxnY29iZXJ0QG9wZW5tb3Rpb24uZnI+
iGEEExECACEFAlbcFMUCGwMFCwkIBwIGFQgJCgsCBBYCAwECHgECF4AACgkQab79
RlFDcvZkVwCeNV/cDNnKFfHb8OCD+/oiOe+R+DcAn03anHUAuLLTmWDcOxiRRyqD
/vKonQFgBFbcFMUQBADU0R1iDeyJRLjh/qoRqwcx3B8wcViLNDAFSss/kGrmgmQs
4DvNCjoe5U8TEKD8CtK4quNPiZPA9lQCoUAEC4Zeq6pswoJvsb7IOn8VkxGV1Tk/
m5Bezh7CQ2pH9JIgO8swslD4UKEuExar6ZsD7rEuBU4z69ezBdJcHGS5tJsxewAD
BQQApNoY2VjhXN2AFLMrzp8T/1kdXDo6kWDaI+YZIvVdR/cxI8HcdecIookd79Z7
E49sVM1ytWJGQe7ynS4m8xO9ZX8E3bDlU/glraLVMGFs7tbDITr77uW3chAdmcHT
eiz/Bo2QQMjxxGVnMDmiwZSJAkYr4QO9Elxb2YF6TOrfof3+BwMCIXTvu3pcREHp
stRuFiMzYNJJHdwKg5FyK3jDWLxBaSUDHM6BETEFBCF56UJ0bo9kYruf2V3aIHrz
3LMzvjC1JDwdBu5IAAcaFSud/uDTd4hJBBgRAgAJBQJW3BTFAhsMAAoJEGm+/UZR
Q3L2IXgAnihV4IeGF30ieN9peDYyeE7TYK2HAJ9asz+OmEECwqavpymFQvxEERCP
mw==
=ulCp
-----END PGP PRIVATE KEY BLOCK-----
') As privkey) As keys; |
Partager