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

DB_VIEWS

DB_VIEWS displays the description about all views accessible to the current user. This view exists in both PG_CATALOG and SYS schema.

Table 1 DB_VIEWS columns

Name

Type

Description

owner

name

Owner of a view.

view_name

name

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.