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

MY_VIEWS

MY_VIEWS displays information about all views of the current user. This view exists in both PG_CATALOG and SYS schema.

Table 1 MY_VIEWS columns

Name

Type

Description

owner

character varying(64)

Owner of a view.

view_name

character varying(64)

View name.

text

text

View text.

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.