The view views contains all views defined in the
current database. Only those views are shown that the current user
has access to (by way of being the owner or having some privilege).
Table 31-39. views Columns
Name
Data Type
Description
table_catalog
sql_identifier
Name of the database that contains the view (always the current database)
table_schema
sql_identifier
Name of the schema that contains the view
table_name
sql_identifier
Name of the view
view definition
character_data
Query expression defining the view (null if the current user is
not the owner of the view)