Updated on 2024-05-07 GMT+08:00

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.