OID

On this page Carat arrow pointing down
Warning:
CockroachDB v22.1 is no longer supported as of November 24, 2023. For more details, refer to the Release Support Policy.

The object identifier (OID) data type stores an unsigned 32-bit integer value.

OIDs are used internally as primary keys for tables in system catalogs, notably information_schema and pg_catalog.

CockroachDB supports many functions that accept OIDs as argument types and return OIDs, and operators that operate on OIDs and other data types. These functions are used by drivers and ORMs and you can use these functions to introspect your schema.

Size

A OID value is 32 bits in width.

Limitations

You should not:

  • Use OIDs in user-created tables. Values of this type are not guaranteed to be stable across major releases.
  • Rely on OIDs to be globally unique. Each OID subtype is unique only within a certain namespace.

See also


Yes No
On this page

Yes No