Postgresql 9.3+ - Support for Materialized Views
Hello,
I noticed, that materialized views are missing from the metadata tree. Since they (almost) behave like normal views (or rather a read-only table with a view as definition), I imagine it wouldn't be hard to integrate them into FlySpeed SQL Query, would it?
From my point of view, one would just have to modify the internal query for the metadata retrieval to include materialized views, give them a special icon, place them under "Views" and done.
Am I seeing this to naively?
Best regards,
Chris
P.S.: I love your tool! Been using it for some time and I'm a happy, paying customer. Keep it up!
I noticed, that materialized views are missing from the metadata tree. Since they (almost) behave like normal views (or rather a read-only table with a view as definition), I imagine it wouldn't be hard to integrate them into FlySpeed SQL Query, would it?
From my point of view, one would just have to modify the internal query for the metadata retrieval to include materialized views, give them a special icon, place them under "Views" and done.
Am I seeing this to naively?
Best regards,
Chris
P.S.: I love your tool! Been using it for some time and I'm a happy, paying customer. Keep it up!
We will add support for materialized views in the next build.