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


1
2
3
4
5
6
7
8

--
-- Materialized views
--

CREATE MATERIALIZED VIEW ddl_deparse_mv AS
  SELECT * FROM datatype_table LIMIT 1 WITH NO DATA;

REFRESH MATERIALIZED VIEW ddl_deparse_mv;