DB_VIEWS
DB_VIEWS displays the description about all views accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.
Name |
Type |
Description |
---|---|---|
owner |
name |
Owner of a view. |
view_name |
name |
Name of a view. |
text |
text |
Text of a view. |
text_length |
integer |
Text length of a 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