↑↓ select ↵ open ⌫ change scope Open full search

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

Documentation / Object Identifier 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 row within its table.

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

Related entries

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