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.

**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. Set it to 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. Set it to NULL.
instantiable	character varying(3)	Not supported. Set it to NULL.
persistable	character varying(3)	Not supported. Set it to NULL.
supertype_owner	character varying(128)	Not supported. Set it to NULL.
supertype_name	character varying(128)	Not supported. Set it to NULL.
local_attributes	numeric	Not supported. Set it to NULL.
local_methods	numeric	Not supported. Set it to NULL.
typeid	raw	Not supported. Set it to NULL.