Skip to content

Fix #7663 - add in_search_path function, correctly show temporary views in SHOW TABLES, and show views in SHOW ALL TABLES #7680

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
Merged
merged 5 commits into from
May 27, 2023
Merged

Fix #7663 - add in_search_path function, correctly show temporary views in SHOW TABLES, and show views in SHOW ALL TABLES #7680

merged 5 commits into from
May 27, 2023

Conversation

Mytherin
Copy link
Collaborator

Fixes #7663

The in_search_path function can be used to check if a given database/schema combo is in the active search path:

D SELECT in_search_path('memory', 'main') AS in_search_path;
┌────────────────┐
│ in_search_path │
│    boolean     │
├────────────────┤
│ true           │
└────────────────┘

This is used as part of SHOW TABLES to now correctly show all tables and views that can be queried - including temporary tables/views.

@Mytherin Mytherin merged commit 9e89e66 into duckdb:master May 27, 2023
@Mytherin Mytherin deleted the showtables branch July 5, 2023 03:40
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

Neither SHOW TABLES nor SHOW ALL TABLES show temporary views
1 participant
@Mytherin