48.75. pg_views

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

Table 48-76. 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.4/view-pg-views.html