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)

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