↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / OID Types / Transaction and row identifiers

tid

tid

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 ro…

Reading PostgreSQL 18.6.

Description

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.

System columns
ctid

Related entries

Documentation and source

Source build
Version
18.6
Build
PostgreSQL 18.6 Documentation
Source fingerprint
8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38

Compare versions

PostgreSQL 17 → 18: unchanged.

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

Export JSON · Back to OID Types · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.