Wiki / OID Types

Definitions for PostgreSQL 18

• cidTransaction and row identifiers10 – 20

  A third identifier type used by the system is cid , or command identifier. This is the data type of the system columns cmin and cmax . Command identifiers are also 32-bit quantities.

  1011121314151617181920
• oidObject identifiers10 – 20

  numeric object identifier.

  1011121314151617181920
• regclassObject name aliases10 – 20

  relation name.

  1011121314151617181920
• regcollationObject name aliases13 – 20

  collation name.

  1011121314151617181920
• regconfigObject name aliases10 – 20

  text search configuration.

  1011121314151617181920
• regdictionaryObject name aliases10 – 20

  text search dictionary.

  1011121314151617181920
• regnamespaceObject name aliases10 – 20

  namespace name.

  1011121314151617181920
• regoperObject name aliases10 – 20

  operator name.

  1011121314151617181920
• regoperatorObject name aliases10 – 20

  operator with argument types.

  1011121314151617181920
• regprocObject name aliases10 – 20

  function name.

  1011121314151617181920
• regprocedureObject name aliases10 – 20

  function with argument types.

  1011121314151617181920
• regroleObject name aliases10 – 20

  role name.

  1011121314151617181920
• regtypeObject name aliases10 – 20

  data type name.

  1011121314151617181920
• tidTransaction and row identifiers10 – 20

  A final identifier type used by the system is tid , or tuple identifier (row identifier). This is the data type of the system column ctid . A tuple ID is a pair (block number, tuple index within block) that identifies the physical location of the row within its table.

  1011121314151617181920
• xidTransaction and row identifiers10 – 20

  Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster. See Section 67.1 for more details.

  1011121314151617181920
• xid8Transaction and row identifiers13 – 20

  Another identifier type used by the system is xid , or transaction (abbreviated xact ) identifier. This is the data type of the system columns xmin and xmax . Transaction identifiers are 32-bit quantities. In some contexts, a 64-bit variant xid8 is used. Unlike xid values, xid8 values increase strictly monotonically and cannot be reused in the lifetime of a database cluster. See Section 67.1 for more details.

  1011121314151617181920