Skip to main content

SHOW VIEWS

Use the SHOW VIEW command to list existing views in a particular schema.

Syntax

SHOW VIEWS [FROM schema_name];

Parameters

ParameterDescription
schema_nameThe schema from which existing views will be listed. If not given, views from the default schema, "public", will be listed.

Example

Say we create the table t3 in the public schema and a view v3.

CREATE TABLE IF NOT EXISTS t3 (
v1 int,
v2 int,
v3 int)
WITH (appendonly = 'true');

CREATE VIEW v3 AS SELECT sum(v2) AS sum_v2 FROM t3;

Then we can use SHOW VIEWS to show the existing views.

SHOW VIEWS FROM public;
v3

CREATE VIEW

SHOW CREATE VIEW

Help us make this doc better!