duckdb / duckdb/duckdb-postgres

postgres scanner not work on partition table

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

Description

The full table copy operation performed by the DuckDB PostgreSQL extension on partitioned tables, such as
```
SELECT *
FROM pg.sch.tb a
left join b on a.x=b.x
where a.dt=current_date
```
, checks the process for full table copy. Under what conditions is it pushed down?
now, this sql need like this:
```
with a as (select * from postgres_query('pg',$$select * from sch.tb$$))
select * from a
left join b on a.x=b.x
```

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.