Skip to content

Should Postgres JSON types map to DuckDB JSON type? #308

@jorinvo

Description

@jorinvo

Hi, thank you for this super useful extension!
I noticed that if I query a JSON or JSONB Postgres column, the type in DuckDB is VARCHAR.
I was wondering if this is intentional, and what's the reasoning behind it.
Since DuckDB has its own JSON type, I intuitively expected that I could directly query Postgres JSON as such within extra conversion.

Thank you.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions