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)