← Back to branch summary

~ubuntu-branches/ubuntu/precise/postgresql-9.1/precise-security

« back to all changes in this revision

Viewing changes to contrib/pgcrypto/sql/pgp-pubkey-encrypt.sql

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
Import upstream version 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
contrib/pgcrypto/sql/pgp-pubkey-encrypt.sql
 
1
--
 
2
-- PGP Public Key Encryption
 
3
--
 
4
-- ensure consistent test output regardless of the default bytea format
 
5
SET bytea_output TO escape;
 
6
 
 
7
-- successful encrypt/decrypt
 
8
select pgp_pub_decrypt(
 
9
        pgp_pub_encrypt('Secret msg', dearmor(pubkey)),
 
10
        dearmor(seckey))
 
11
from keytbl where keytbl.id=1;
 
12
 
 
13
select pgp_pub_decrypt(
 
14
                pgp_pub_encrypt('Secret msg', dearmor(pubkey)),
 
15
                dearmor(seckey))
 
16
from keytbl where keytbl.id=2;
 
17
 
 
18
select pgp_pub_decrypt(
 
19
                pgp_pub_encrypt('Secret msg', dearmor(pubkey)),
 
20
                dearmor(seckey))
 
21
from keytbl where keytbl.id=3;
 
22
 
 
23
select pgp_pub_decrypt(
 
24
                pgp_pub_encrypt('Secret msg', dearmor(pubkey)),
 
25
                dearmor(seckey))
 
26
from keytbl where keytbl.id=6;
 
27
 
 
28
-- try with rsa-sign only
 
29
select pgp_pub_decrypt(
 
30
                pgp_pub_encrypt('Secret msg', dearmor(pubkey)),
 
31
                dearmor(seckey))
 
32
from keytbl where keytbl.id=4;
 
33
 
 
34
-- try with secret key
 
35
select pgp_pub_decrypt(
 
36
                pgp_pub_encrypt('Secret msg', dearmor(seckey)),
 
37
                dearmor(seckey))
 
38
from keytbl where keytbl.id=1;
 
39
 
 
40
-- does text-to-bytea works
 
41
select pgp_pub_decrypt_bytea(
 
42
                pgp_pub_encrypt('Secret msg', dearmor(pubkey)),
 
43
                dearmor(seckey))
 
44
from keytbl where keytbl.id=1;
 
45
 
 
46
-- and bytea-to-text?
 
47
select pgp_pub_decrypt(
 
48
                pgp_pub_encrypt_bytea('Secret msg', dearmor(pubkey)),
 
49
                dearmor(seckey))
 
50
from keytbl where keytbl.id=1;