select open change scope Open full search

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

Extensions / Data types

pg_datatype_password

SQL-only password data type and operators using pgcrypto Blowfish hashes, with trigger-based encryption before storage.

pgext.cloud · Source code · Documentation · License text · Control file · PGXN

Overview

Packagepg_datatype_password
Version0.0.1
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemapublic
Stars6
Latest commit2016-12-25
Latest release2016-12-21
Catalogue updated2026-08-30

Related extensions

Requires

pgcryptocryptographic functions
plpgsqlPL/pgSQL procedural language

See also

pgocryptoencrypt data between Go and PG
shacryptImplements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
cryptintEncryption functions for int and bigint values
all_in_one_libRust/pgrx utility extension with encryption helpers and a sample FDW wrapper.
pg_themisPostgreSQL encryption and decryption functions backed by the Themis cryptographic library.
eqlEncrypt Query Language provides PostgreSQL types, functions, operators, and index support for searchable encrypted data.
rds_tde_utilsAlibaba Cloud RDS extension for batch TDE encryption and decryption of tables and indexes.
pg_pii_vaultPostgreSQL extension for GDPR-compliant column-level encryption using HashiCorp Vault Transit Engine.
rds_encdbAlibaba Cloud RDS sensitive-column result encryption extension
open_pg_tdeTransparent data encryption for upstream PostgreSQL using the tde_heap access method, including tables, indexes, TOAST, WAL, and temporary files.
ccnumberdata type representing encrypted CC numbers
tceTransparent column encryption for PostgreSQL using per-role envelope keys and external key-management services.