MY_VIEWS

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

**Table 1** MY_VIEWS columns
Name	Type	Description
owner	character varying(64)	Owner of the view.
view_name	character varying(64)	Name of the view.
text	text	Text of 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. Set it to NULL.
type_text	character varying(4000)	Not supported. Set it to NULL.
oid_text_length	numeric	Not supported. Set it to NULL.
oid_text	character varying(4000)	Not supported. Set it to NULL.
view_type_owner	character varying(128)	Not supported. Set it to NULL.
view_type	character varying(128)	Not supported. Set it to NULL.
superview_name	character varying(128)	Not supported. Set it to NULL.
editioning_view	character varying(1)	Not supported. Set it to NULL.
read_only	character varying(1)	Not supported. Set it to NULL.
container_data	character varying(1)	Not supported. Set it to NULL.
bequeath	character varying(12)	Not supported. Set it to NULL.
origin_con_id	character varying(256)	Not supported. Set it to NULL.
default_collation	character varying(100)	Not supported. Set it to NULL.
containers_default	character varying(3)	Not supported. Set it to NULL.
container_map	character varying(3)	Not supported. Set it to NULL.
extended_data_link	character varying(3)	Not supported. Set it to NULL.
extended_data_link_map	character varying(3)	Not supported. Set it to NULL.
has_sensitive_column	character varying(3)	Not supported. Set it to NULL.
admit_null	character varying(3)	Not supported. Set it to NULL.
pdb_local_only	character varying(3)	Not supported. Set it to NULL.