Documentation
 
 
 

1.51. pg_views

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

Table 1-51. pg_views Columns

NameTypeReferencesDescription
schemanamenamepg_namespace.nspnameName of schema containing view
viewnamenamepg_class.relnameName of view
viewownernamepg_authid.rolnameName of view's owner
definitiontext View definition (a reconstructed SELECT query)
 
 ©2004-2007 EnterpriseDB All Rights Reserved