MY_VIEWS
MY_VIEWS displays information about all views of the current user. This view exists in the PG_CATALOG and SYS schemas. For details about the columns, see Table 1.
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. 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot