postgres_scanner icon indicating copy to clipboard operation
postgres_scanner copied to clipboard

Published 20 hours ago • verified publisher icon duckdb

Should Postgres JSON types map to DuckDB JSON type?

Open jorinvo opened this issue 7 months ago • 0 comments

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.

jorinvo avatar Mar 19 '25 07:03 jorinvo