54.35. pg_views

The view pg_views provides access to useful information about each view in the database.

Table 54.35. pg_views Columns

Column Type

Description

schemaname name (references pg_namespace . nspname )

Name of schema containing view

viewname name (references pg_class . relname )

Name of view

viewowner name (references pg_authid . rolname )

Name of view's owner

definition text

View definition (a reconstructed SELECT query)