Implement pg_catalog.pg_matviews

[hlcianfagna]

Problem Statement

Some tools (see labels) run queries that look for this system view.

https://www.postgresql.org/docs/current/view-pg-matviews.html

Possible Solutions

Implement it empty

Considered Alternatives

• For dbt --> use the overrides from https://community.cratedb.com/t/using-dbt-with-cratedb/1566

• Metabase explicitly looks for the view under pg_catalog

CREATE TABLE pg_catalog.pg_matviews (
	schemaname TEXT,	matviewname TEXT,	matviewowner TEXT,
	tablespace TEXT,	hasindexes BOOLEAN,	ispopulated BOOLEAN,
	definition text	);

--> SQLParseException[Cannot create relation in read-only schema: pg_catalog]

---

• Relates to Support for Materialized Views #10661