duckdb / duckdb/duckdb-postgres
Should Postgres JSON types map to DuckDB JSON type?
Open
- 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.