Development Versions: devel

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)

|