summaryrefslogtreecommitdiff
path: root/contrib/pgcrypto/sql/pgp-info.sql
blob: d979bb93d97e2862cb45ae35e5f0724484513050 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
--
-- PGP info functions
--

-- pgp_key_id

select pgp_key_id(dearmor(pubkey)) from keytbl where id=1;
select pgp_key_id(dearmor(pubkey)) from keytbl where id=2;
select pgp_key_id(dearmor(pubkey)) from keytbl where id=3;
select pgp_key_id(dearmor(pubkey)) from keytbl where id=4; -- should fail
select pgp_key_id(dearmor(pubkey)) from keytbl where id=5;

select pgp_key_id(dearmor(seckey)) from keytbl where id=1;
select pgp_key_id(dearmor(seckey)) from keytbl where id=2;
select pgp_key_id(dearmor(seckey)) from keytbl where id=3;
select pgp_key_id(dearmor(seckey)) from keytbl where id=4; -- should fail
select pgp_key_id(dearmor(seckey)) from keytbl where id=5;

select pgp_key_id(dearmor(data)) as data_key_id
from encdata order by id;