pg_views
The view pg_views provides access to useful information about each view in the database.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- view
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- schemaname, viewname, viewowner, definition
- runtime verified
- false
- source
- english-manual
Definition PG 18
The view pg_views provides access to useful information about each view in the database.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| schemaname | name | Nullable | Name of schema containing view |
| viewname | name | Nullable | Name of view |
| viewowner | name | Nullable | Name of view's owner |
| definition | text | Nullable | View definition (a reconstructed SELECT query) |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:4378e0d315fc7ec1d4638c31668e477672fef2533b974316a7105bf7ca1176c4
Text language: en · catalog-bilingual-repair:4378e0d315fc7ec1d4638c31668e477672fef2533b974316a7105bf7ca1176c4