pg_views

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

Columns 4

Column	Type	Description / reference
`schemaname`	`name`	Name of schema containing view pg_namespace.nspname
`viewname`	`name`	Name of view pg_class.relname
`viewowner`	`name`	Name of view's owner pg_authid.rolname
`definition`	`text`	View definition (a reconstructed SELECT query)

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`schemaname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`viewname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`viewowner`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`definition`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Definition snapshot: english-manuals:506f3d417c5c9e8ab44046b66ad… · English manual source