don't see materialized views in information_schema

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Subject: don't see materialized views in information_schema
Date: 2019-09-11 06:14:21
Message-ID: CAFj8pRAkrGFm5BEAj_xK9pYLZ6YSF39shUTp9z8DcX7rqQNNCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Nelson 2019-09-11 06:22:12 Re: Change atoi to strtol in same place
Previous Message Pavel Stehule 2019-09-11 06:09:40 Re: doc: update PL/pgSQL sample loop function