​
Syntax

SHOW CREATE VIEW view_name;

​
Parameters

ParameterDescription
view_nameThe view to show the query of.

​
Example

CREATE VIEW v1 AS SELECT id FROM taxi_trips;
SHOW CREATE VIEW v1;
Here is the result. 
   Name    |                 Create Sql
-----------+---------------------------------------------
 public.v1 | CREATE VIEW v1 AS SELECT id FROM taxi_trips
(1 row)

SHOW CREATE MATERIALIZED VIEW

SHOW CREATE TABLE