Use the SHOW CREATE MATERIALIZED VIEW command to see what query was used to create the specified materialized view.
SHOW CREATE MATERIALIZED VIEW
SHOW CREATE MATERIALIZED VIEW mv_name;
CREATE MATERIALIZED VIEW v1 AS SELECT id FROM taxi_trips; SHOW CREATE MATERIALIZED VIEW v1;
Name | Create Sql -----------+--------------------------------------------- public.v1 | CREATE MATERIALIZED VIEW v1 AS SELECT id FROM taxi_trips (1 row)
Was this page helpful?