src/test/modules/test_ddl_deparse/sql/matviews.sql


1
2
3
4
5
6
7
8

--
-- Materialized views
--

CREATE MATERIALIZED VIEW pg_class_mv AS
  SELECT * FROM pg_class LIMIT 1 WITH NO DATA;

REFRESH MATERIALIZED VIEW pg_class_mv;