The view pg_views provides access to useful information about each view in the database.
Table 42-46. pg_views Columns
| Name |
Type |
References |
Description |
|
schemaname
|
name
|
pg_namespace
.nspname
|
name of schema containing view |
|
viewname
|
name
|
pg_class
.relname
|
name of view |
|
viewowner
|
name
|
pg_authid
.rolname
|
name of view's owner |
|
definition
|
text
|
|
view definition (a reconstructed SELECT query) |
