duckdb / duckdb/duckdb-postgres

Should Postgres JSON types map to DuckDB JSON type?

Open
#308 0 comments 7 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
372
Forks
105
Avg merge
10h 19m
Merged PRs (30d)
18

Description

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.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.