DB_VIEWS
DB_VIEWS displays the description about all views accessible to the current user. This view exists in both the PG_CATALOG and SYS schemas.
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.