DB_TYPES

DB_TYPES displays all object types accessible to the current user. All users can access this view. This view exists in both PG_CATALOG and SYS schema.

**Table 1** DB_TYPES columns
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. Its value is 0.
predefined	character varying(3)	Specifies whether the type is a predefined type.
incomplete	character varying(3)	Specifies whether the type is incomplete.
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.