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.

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

Materialized views not identified as "table or view" #1880

Open
grufgran opened this issue Dec 9, 2023 · 0 comments
Open

Materialized views not identified as "table or view" #1880

grufgran opened this issue Dec 9, 2023 · 0 comments

Comments

@grufgran
Copy link

grufgran commented Dec 9, 2023

Is your feature request related to a problem? Please describe.
When I'm writing a query in the editor (connected to postgres) and write the schema name and then a dot, I get list of possible objects. For example function names, table names, view names and so on. Which is GREAT!!
But, in the list, there is no materialized views. It would be great, if those also appeared in the list.

Also, when write a table alias and a dot, I get a list of columns in that table. Which is GREAT!!
But, when it is a table alias for materialized view, no column list appear. It would be fantastic if there would appear a column list for materialized views also.

Describe the solution you'd like

  1. When I write: "select * from myschema." I get a list of tables, views, functions. But no materialized views. I would be great if materialized views also appeared in the list
  2. When I write: "select t. from myschema.mytable t" I get a list of columns in table t. But if t is a materialized view, no column list appear. It would be great if a materialized view columns also appeared in the list.

Describe alternatives you've considered
Table/view/funciont list appended with materialized views and column list also working with materialized views

Additional context
Add any other context or screenshots about the feature request here.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant