50.83. pg_views

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

Table 50-84. pg_views Columns

Name	Type	References	Description
`schemaname`	`name`	`pg_namespace.nspname`	Name of schema containing view
`viewname`	`name`	`pg_class.relname`	Name of view
`viewowner`	`name`	`pg_authid.rolname`	Name of view's owner
`definition`	`text`		View definition (a reconstructed `SELECT` query)

Prev		Next
`pg_user_mappings`	Up	Frontend/Backend Protocol

© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/9.6/view-pg-views.html