postgres-data-sanitizers¶

PostgreSQL data sanitization: null character escaping, surrogate detection, JSONB-safe dictionaries.

Installation¶

pip install postgres-data-sanitizers

Public API¶

Function	Purpose
`escape_null_chars(text) -> str`	Escape `\x00` to unicode representation
`unescape_null_chars(text) -> str`	Reverse escape
`sanitize_dict_for_postgres(data) -> dict`	Recursively escape nulls in dict (JSONB)
`unescape_dict_from_postgres(data) -> dict`	Reverse dict escape
`validate_postgres_text(text) -> str\|None`	Validate and escape text for storage
`contains_surrogates(text) -> bool`	Detect UTF-8 surrogate characters

Usage¶

from postgres_data_sanitizers import sanitize_dict_for_postgres

safe = sanitize_dict_for_postgres({"bio": "text\x00with\x00nulls"})
# nulls escaped for PostgreSQL JSONB storage