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)