Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

add support for search_path for tables #18

Closed
wuputah opened this issue Apr 24, 2024 · 2 comments
Closed

add support for search_path for tables #18

wuputah opened this issue Apr 24, 2024 · 2 comments
Assignees
@mkaruza
Milestone
0.1.0 code complete

Comments

@wuputah
Copy link
Collaborator

wuputah commented Apr 24, 2024

SET search_path = 'foo'; should then make it so that SELECT * FROM bar returns data from foo.bar rather than public.bar.

Note that search_path is a comma-separated list, and also impacts lookup of functions, etc.
@wuputah wuputah added this to the postgres-features milestone Apr 24, 2024
@Mytherin
Copy link
Collaborator

@Tishj can you investigate what this looks like at the DuckDB level w.r.t. replacement scans

@Mytherin Mytherin assigned mkaruza and unassigned Tishj May 13, 2024
@mkaruza
Copy link
Collaborator

mkaruza commented May 27, 2024

#33

@mkaruza mkaruza closed this as completed May 27, 2024
@wuputah wuputah added this to the 0.1.0 milestone May 27, 2024
@wuputah wuputah added this to pg_duckdb Aug 5, 2024
@wuputah wuputah moved this to Done in pg_duckdb Aug 6, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mkaruza mkaruza

Labels
None yet
Projects
pg_duckdb
Status: Done
Milestone
0.1.0 code complete
Development

No branches or pull requests
4 participants
@wuputah @mkaruza @Mytherin @Tishj