-
-
Notifications
You must be signed in to change notification settings - Fork 563
Materialized views not identified as "table or view" #1880
Description
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
- 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
- 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.