Documentation
SQL Reference
Part I. Tutorial
Part II. The SQL Language
Part III. Server Administration
Part IV. Reference
Part V. Internals
System Catalogs
Overviewpg_aggregatepg_attrdefpg_attributepg_authidpg_auth_memberspg_castpg_classpg_collationpg_constraintpg_conversionpg_databasepg_db_role_settingpg_default_aclpg_dependpg_descriptionpg_enumpg_event_triggerpg_extensionpg_foreign_data_wrapperpg_foreign_serverpg_foreign_tablepg_indexpg_inheritspg_languagepg_namespacepg_operatorpg_policypg_procpg_rangepg_rewritepg_seclabelpg_sequencepg_shdependpg_shdescriptionpg_shseclabelpg_tablespacepg_typeSystem Viewspg_available_extensionspg_indexespg_lockspg_matviewspg_prepared_statementspg_prepared_xactspg_rolespg_seclabelspg_settingspg_shadowpg_tablespg_userpg_views
Part VI. Appendixes
Legal Notice
SQL ReferencePart V. InternalsSystem Catalogs

pg_views

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

Table 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)

Previous

pg_user

Next

Part VI. Appendixes