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 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.