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

Reply via email to