Development Versions: devel
The view pg_views provides access to useful information about each view in the database.
Table 53.37. 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)
|