select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Security

pgcrypto

cryptographic functions

pgext.cloud · Website · Documentation · License text · Control file

Overview

Packagepgcrypto
Version1.3
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPostgreSQL contrib
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedYes
Latest commit2026-05-14
Latest release2026-05-14
Catalogue updated2026-07-29

Related extensions

Required by

bedquiltA json object store
bundledata version control system
column_encryptTransparent column-level encryption with encrypted_text and encrypted_bytea types
cos_fdwTencentDB PostgreSQL foreign data wrapper for reading CSV data from Tencent Cloud Object Storage (COS).
efm_extensionSQL interface for EDB Failover Manager cluster management
geekspeakDatabase schema extension for the GeekSpeak podcast website.
gitgresStore Git objects and refs in PostgreSQL tables with SQL functions and a native git_oid type.
hello-worldRLS demo extension with users and products tables
keyhippoRLS-compatible API keys for PostgreSQL
launchql-base32RFC6238 TOTP implementation in pure PostgreSQL plpgsql
launchql-totp🛠. basic pg utils
maludb_coreA memory DBMS for long-term institutional memory, human-AI knowledge sharing, and contextual recall. PostgreSQL 17 extension.
omni_authBasic session management
omni_awsAmazon Web Services APIs (S3)
omni_credentialsApplication credential management
omni_restREST API toolkit (with PostgREST support)
pg_datatype_passwordSQL-only password data type and operators using pgcrypto Blowfish hashes, with trigger-based encryption before storage.
pg_dispatchAsynchronous SQL dispatcher built on pg_cron
pg_doc_storeProvides a JSONB document-store API with full-text search.
pg_fasttransferPostgresql Extension for FastTransfer
pg_fediPure-SQL ActivityPub federation primitives for PostgreSQL and pg_tle environments.
pg_gen_uidAdds a PL/pgSQL function that generates random lowercase alphanumeric identifiers using pgcrypto.
pg_gitImplements Git-like repositories, commits, branches, merges and remote operations using PostgreSQL-native data and functions.
pg_semantiusDatabase-first application backend with RBAC, RLS, data dictionary, and message queue.
pg_tamperlogTamper-evident append-only audit logging with hash chaining
pgckConcept Kernel runtime with NATS transport, SHACL validation, and RDF materialization.
pgcryptokeycryptographic key management
pggitGit-like version control for PostgreSQL schemas
pgjwtJSON Web Token API for Postgresql
pgocryptoencrypt data between Go and PG
pgpm-base32PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.
pgpm-fakerPostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.
postgres_ciImplements the database backend for the defunct Postgres-CI service, including users, projects, builds, hooks, sessions, and notifications.
rule_engine_postgre_extensionsRust/pgrx rule-engine extension supporting GRL rules, RETE and forward/backward chaining, versioned rule repositories, triggers, and optional external integrations.
skitch-extension-jobsAn asynchronous job queue schema for ACID compliant job creation
softvisio_adminProprietary SQL administration extension for database/role provisioning and cluster-wide extension inventory and updates via dblink.
supa_agent_traceA browser extension and agent for Supabase
synchdbMixed C/Java PostgreSQL extension for direct CDC replication from MySQL, SQL Server, Oracle, and OpenLog Replicator sources.
tencentdb_aiTencentDB extension for calling large-model APIs and building in-database RAG workflows.
veil2Provides the basis for a Virtual Private Database implementation.
webauthnPure-SQL PostgreSQL implementation of WebAuthn credential registration and assertion verification.

See also

pgsodiumPostgres extension for libsodium functions
pgsmcryptoPostgreSQL SM Algorithm Extension
pgcryptokeycryptographic key management
pgueccuECC bindings for Postgres
shacryptImplements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
cryptintEncryption functions for int and bigint values
pg_tdePercona pg_tde access method
column_encryptTransparent column-level encryption with encrypted_text and encrypted_bytea types
supabase_vaultSupabase Vault Extension
pg_enigmaEncrypted postgres data type
hashlibStable hash functions for Postgres
xxhashxxhash functions for PostgreSQL