SHOW CREATE MATERIALIZED VIEW

Use the SHOW CREATE MATERIALIZED VIEW command to see what query was used to create the specified materialized view.

Syntax

SHOW CREATE MATERIALIZED VIEW mv_name;

Parameters

Parameter	Description
mv_name	The materialized view to show the query of.

Example

CREATE MATERIALIZED VIEW v1 AS SELECT id FROM taxi_trips;
SHOW CREATE MATERIALIZED VIEW v1;

Here is the result.

   Name    |                 Create Sql
-----------+---------------------------------------------
 public.v1 | CREATE MATERIALIZED VIEW v1 AS SELECT id FROM taxi_trips
(1 row)

Related topics

SHOW CREATE VIEW

SHOW CREATE TABLE

SHOW CREATE VIEW

SHOW CREATE TABLE