Contents
pgcrypto
A contrib module providing various cryptographic functions
pgcrypto
is a contrib module providing various cryptographic functions.
pgcrypto
was added in PostgreSQL 7.1.
Change history
- PostgreSQL 15
- will only built if OpenSSL support is configured (commit db7d1a7b)
- PostgreSQL 13
- function
gen_random_uuid()
converted to a core system function (commit 5925e554) - marked as a
trusted extension
(commit eb67623c)
- function
- PostgreSQL 9.6 (extension version 1.3):
- parallel query support added (commit 0dbf3ce0)
- PostgreSQL 9.5 (extension version 1.2):
- function
pgp_armor_headers()
added (commit 32984d8f)
- function
- PostgreSQL 9.4 (extension version 1.1):
- function
gen_random_uuid()
added (commit e6170126)
- function
- PostgreSQL 9.1
- PostgreSQL 8.2
gen_random_bytes()
function added (commit 1abf76e8)
- PostgreSQL 8.1
- implementation of OpenPGP symmetric-key and public-key encryption, including following new functions (commit 73e24318):
pgp_pub_encrypt()
pgp_pub_decrypt()
pgp_pub_encrypt_bytea()
pgp_pub_decrypt_bytea()
pgp_sym_encrypt()
pgp_sym_decrypt()
pgp_sym_encrypt_bytea()
pgp_sym_decrypt_bytea()
- implementation of OpenPGP symmetric-key and public-key encryption, including following new functions (commit 73e24318):
- PostgreSQL 7.2
- following functions added (commit 2518e273):
crypt()
hmac()
decrypt()
encrypt()
gen_salt()
- following functions added (commit 2518e273):
- PostgreSQL 7.1
- added (commit 0c0dde61), initially providing hashing functions.
References
- PostgreSQL documentation: pgcrypto