pgcrypto is a contrib module providing various cryptographic functions.
pgcrypto was originally added in PostgreSQL 7.1 (commit 0c0dde61).
Change history
- 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