LangChain Reference home pageLangChain ReferenceLangChain Reference
  • GitHub
  • Main Docs
Deep Agents
LangChain
LangGraph
Integrations
LangSmith
  • Overview
    • Overview
    • Caches
    • Callbacks
    • Documents
    • Document loaders
    • Embeddings
    • Exceptions
    • Language models
    • Serialization
    • Output parsers
    • Prompts
    • Rate limiters
    • Retrievers
    • Runnables
    • Utilities
    • Vector stores
    MCP Adapters
    Standard Tests
    Text Splitters
    ⌘I

    LangChain Assistant

    Ask a question to get started

    Enter to send•Shift+Enter new line

    Menu

    OverviewCachesCallbacksDocumentsDocument loadersEmbeddingsExceptionsLanguage modelsSerializationOutput parsersPromptsRate limitersRetrieversRunnablesUtilitiesVector stores
    MCP Adapters
    Standard Tests
    Text Splitters
    Language
    Theme
    Pythonlangchain-coreutilsstringssanitize_for_postgres
    Function●Since v0.3

    sanitize_for_postgres

    Sanitize text by removing NUL bytes that are incompatible with PostgreSQL.

    PostgreSQL text fields cannot contain NUL (0x00) bytes, which can cause psycopg.DataError when inserting documents. This function removes or replaces such characters to ensure compatibility.

    Copy
    sanitize_for_postgres(
        text: str,
        replacement: str = '',
    ) -> str

    Example:

    sanitize_for_postgres("Hello\x00world") 'Helloworld' sanitize_for_postgres("Hello\x00world", " ") 'Hello world'

    Parameters

    NameTypeDescription
    text*str

    The text to sanitize.

    replacementstr
    Default:''

    String to replace NUL bytes with.

    View source on GitHub