51.95. pg_views

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

Table 51.96. 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)
Prev Up Next
51.94. pg_user_mappings Home Chapter 52. Frontend/Backend Protocol

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