Hi create table omega(a int); create view omega_view as select * from omega; insert into omega values(10);
postgres=# select table_type, table_name from information_schema.tables where table_name like 'omega%'; ┌────────────┬────────────┐ │ table_type │ table_name │ ╞════════════╪════════════╡ │ BASE TABLE │ omega │ │ VIEW │ omega_view │ └────────────┴────────────┘ (2 rows) postgres=# create materialized view omega_m_view as select * from omega; SELECT 1 postgres=# select table_type, table_name from information_schema.tables where table_name like 'omega%'; ┌────────────┬────────────┐ │ table_type │ table_name │ ╞════════════╪════════════╡ │ BASE TABLE │ omega │ │ VIEW │ omega_view │ └────────────┴────────────┘ (2 rows) postgres=# refresh materialized view omega_m_view ; REFRESH MATERIALIZED VIEW postgres=# select table_type, table_name from information_schema.tables where table_name like 'omega%'; ┌────────────┬────────────┐ │ table_type │ table_name │ ╞════════════╪════════════╡ │ BASE TABLE │ omega │ │ VIEW │ omega_view │ └────────────┴────────────┘ (2 rows) Is it expected behave? Tested on master branch. Pavel