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)
doc_PostgreSQL
2016-10-12 11:32:43
Comments
Leave a Comment

Please login to continue.