53.37. pg_views #

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

   Table 53.37. 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)