postgres_scanner
postgres_scanner copied to clipboard
Published
20 hours ago •
duckdb
duckdb
Views referencing JSON fields in PostgreSQL JSON(B) columns don't show values for them
What happens?
When I execute a SELECT statement on a PostgreSQL table with a JSONB-type column that includes an output column for a field in that column (extracted via a JSONPath expression), that column yields data as expected. If I create a view for the same statement, the column remains empty.
To Reproduce
SELECT id, json_col->'$.some_field' some_field FROM my_psql_table;
-- result contains values in some_field column ✓
CREATE VIEW my_view AS SELECT id, json_col->'$.some_field' some_field FROM my_psql_table;
FROM my_view;
-- result DOES NOT contain values in some_field column
OS:
Linux
PostgreSQL Version:
16.4
DuckDB Version:
1.1.0
DuckDB Client:
CLI
Full Name:
Marco Götze
Affiliation:
(none)
Have you tried this on the latest main branch?
- [X] I agree
Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?
- [X] I agree
