ADM_VIEWS

ADM_VIEWS displays views in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

**Table 1** ADM_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.