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

    Copy
    sanitize_for_postgres(
        text: str,
        replacement: str = '',
    ) -> str
    View source on GitHub

    Parameters

    NameTypeDescription
    text*str

    The text to sanitize.

    replacementstr
    Default:''

    String to replace NUL bytes with.

    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.

    Example:

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