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 the PG_CATALOG and SYS schemas.

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