DB_INDEXES
DB_INDEXES displays information about indexes accessible to the current user. This view exists in both PG_CATALOG and SYS schemas.
|
Name |
Type |
Description |
|---|---|---|
|
owner |
character varying(64) |
Index owner. |
|
index_name |
character varying(64) |
Index name. |
|
table_name |
character varying(64) |
Name of the table corresponding to the index. |
|
uniqueness |
text |
Specifies whether the index is unique. |
|
partitioned |
character(3) |
Specifies whether the index has the property of partitioned tables. |
|
generated |
character varying(1) |
Specifies whether the name of an index is generated by the system. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.