Hi:
I have installed HeidiSQL recently, and tried to interact with it, so far it's simple, intuitive and easy to use.
However one glitch that I consider a big barrier to me, it could't list my Materialized views specifically. the database I've created on postgreSQL PgAdminIII editor.
at the beginning I thought it's a grant permission issue, but after investigation it seems not the issue.
Even though I tried to create a net new materialized view using HeidiSQL, it'll not show it in the Views tree, so I have to open PgAdminIII to editd or manipulte the materialized view.
** I found a post on this fourm who has the same issue before but without an answer so far.
Please advise.
Thanks