Login Register

Catalogs: pg_views

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

Table 50-84. pg_views Columns

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

Prev		Next
`pg_user_mappings`	Up	Frontend/Backend Protocol

Links:

https://www.postgresql.org/docs/9.6/static/view-pg-views.html

doc_PostgreSQL

2025-01-10 15:47:30

Comments

Leave a Comment

Please login to continue.

Popular Articles

Catalogs: pg_trigger The catalog pg_trigger stores triggers on tables and views. See CREATE TRIGGER for more information. Table 50-49. pg_trigger Columns Name Type Refe

Catalogs: pg_am The catalog pg_am stores information about relation access methods. There is one row for each access method supported by the system. Currently, only

Catalogs: pg_authid The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of "users" and "groups". A

Catalogs: pg_pltemplate The catalog pg_pltemplate stores "template" information for procedural languages. A template for a language allows the language to be created in a pa

Catalogs: pg_amop The catalog pg_amop stores information about operators associated with access method operator families. There is one row for each operator that is a