Movatterモバイル変換

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

51.99. `pg_views`

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

Table 51.100. pg_views Columns

Column Type Description
`schemanamename` (references`pg_namespace`.`nspname`) Name of schema containing view
`viewnamename` (references`pg_class`.`relname`) Name of view
`viewownername` (references`pg_authid`.`rolname`) Name of view's owner
`definitiontext` View definition (a reconstructedSELECT query)

Column Type

Description

schemanamename (referencespg_namespace.nspname)

Name of schema containing view

viewnamename (referencespg_class.relname)

Name of view

viewownername (referencespg_authid.rolname)

Name of view's owner

definitiontext

View definition (a reconstructedSELECT query)

Prev	Up	Next
51.98. `pg_user_mappings`	Home	Chapter 52. Frontend/Backend Protocol