pg_views
The view pg_views provides access to useful information about each view in the database.
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) |