51.95. pg_views

51.95. `pg_views`
Prev	Up	Chapter 51. System Catalogs	Home	Next

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)

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