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
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)