Skip to content

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

@grufgran

Description

@grufgran

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    featureA new feature to implementnettype-postgresqlPostgreSQL specific issue

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions