43.38. pg_views

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

Table 43-38. pg_views Columns

NameTypeReferencesDescription
schemanamenamepg_namespace.nspnamename of schema containing view
viewnamenamepg_class.relnamename of view
viewownernamepg_shadow.usenamename of view's owner
definitiontext view definition (a reconstructed SELECT query)