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

Table 49-82. 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)