Postgres Pro Enterprise : Documentation: 17: 54.39. pg

54.39. `pg_views`
Prev	Up	Chapter 54. System Views	Home	Next

54.39. `pg_views` #

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

Table 54.39. 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
54.38. `pg_user_mappings`	Home	54.40. `pg_wait_events`

epub pdf