DB_OBJECTS
DB_OBJECTS displays all database objects accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| owner | name | Object owner. |
| object_name | name | Object name. |
| object_id | oid | OID of the object. |
| object_type | name | Object type. |
| namespace | oid | ID of the namespace where an object resides. |
| temporary | character(1) | Specifies whether an object is a temporary object. |
| status | character varying(7) | Object status.
|
| subobject_name | name | Subobject name of an object. |
| generated | character(1) | Specifies whether an object name is generated by the system. |
| created | timestamp with time zone | Creation time of an object. |
| last_ddl_time | timestamp with time zone | Last time when an object was modified. |
| default_collation | character varying(100) | Default collation of objects. |
| data_object_id | numeric | Not supported. Its value is NULL. |
| timestamp | character varying(19) | Not supported. Its value is NULL. |
| secondary | character varying(1) | Not supported. Its value is NULL. |
| edition_name | character varying(128) | Not supported. Its value is NULL. |
| sharing | character varying(18) | Not supported. Its value is NULL. |
| editionable | character varying(1) | Not supported. Its value is NULL. |
| oracle_maintained | character varying(1) | Not supported. Its value is NULL. |
| application | character varying(1) | Not supported. Its value is NULL. |
| duplicated | character varying(1) | Not supported. Its value is NULL. |
| sharded | character varying(1) | Not supported. Its value is NULL. |
| created_appid | numeric | Not supported. Its value is NULL. |
| modified_appid | numeric | Not supported. Its value is NULL. |
| created_vsnid | numeric | Not supported. Its value is NULL. |
| modified_vsnid | numeric | Not supported. Its value is NULL. |
For details on the value ranges of created and last_ddl_time, see PG_OBJECT.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
