53.37. pg_views

pg_views

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

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)

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)

: pg_views Columns