DB_TYPES
DB_TYPES displays all object types accessible to the current user. All users can access this view. This view exists in the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| owner | character varying(128) | Owner of the type. |
| type_name | character varying(128) | Type name. |
| type_oid | raw | Type OID. |
| typecode | character varying(128) | Type code. |
| attributes | numeric | Number of attributes in a type. |
| methods | numeric | Not supported. The value is 0. |
| predefined | character varying(3) | Specifies whether the type is a predefined type. |
| incomplete | character varying(3) | Specifies whether the type is an incomplete type. |
| final | character varying(3) | Not supported. Its value is NULL. |
| instantiable | character varying(3) | Not supported. Its value is NULL. |
| persistable | character varying(3) | Not supported. Its value is NULL. |
| supertype_owner | character varying(128) | Not supported. Its value is NULL. |
| supertype_name | character varying(128) | Not supported. Its value is NULL. |
| local_attributes | numeric | Not supported. Its value is NULL. |
| local_methods | numeric | Not supported. Its value is NULL. |
| typeid | raw | 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.