MY_VIEWS

MY_VIEWS displays information about all views of the current user. This view exists in both PG_CATALOG and SYS schema.

**Table 1** MY_VIEWS columns
Name	Type	Description
owner	character varying(64)	Owner of a view.
view_name	character varying(64)	View name.
text	text	Text in the view.
text_length	integer	Text length of the view.
TEXT_VC	character varying(4000)	View creation statement. This column may truncate the view text. The BEQUEATH clause will not appear as part of the TEXT_VC column in this view.
type_text_length	numeric	Not supported. Its value is NULL.
type_text	character varying(4000)	Not supported. Its value is NULL.
oid_text_length	numeric	Not supported. Its value is NULL.
oid_text	character varying(4000)	Not supported. Its value is NULL.
view_type_owner	character varying(128)	Not supported. Its value is NULL.
view_type	character varying(128)	Not supported. Its value is NULL.
superview_name	character varying(128)	Not supported. Its value is NULL.
editioning_view	character varying(1)	Not supported. Its value is NULL.
read_only	character varying(1)	Not supported. Its value is NULL.
container_data	character varying(1)	Not supported. Its value is NULL.
bequeath	character varying(12)	Not supported. Its value is NULL.
origin_con_id	character varying(256)	Not supported. Its value is NULL.
default_collation	character varying(100)	Not supported. Its value is NULL.
containers_default	character varying(3)	Not supported. Its value is NULL.
container_map	character varying(3)	Not supported. Its value is NULL.
extended_data_link	character varying(3)	Not supported. Its value is NULL.
extended_data_link_map	character varying(3)	Not supported. Its value is NULL.
has_sensitive_column	character varying(3)	Not supported. Its value is NULL.
admit_null	character varying(3)	Not supported. Its value is NULL.
pdb_local_only	character varying(3)	Not supported. Its value is NULL.