Supported Versions: Current (16) / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

41.39. pg_views

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

Table 41-39. 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_shadow.usename name of view's owner
definition text   view definition (a reconstructed SELECT query)