{"kind": "oid", "major": "18", "item": {"slug": "tid", "name": "tid", "name_zh": "tid", "category": "Transaction and row identifiers", "summary": "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.", "aliases": [], "versions": {"10": {"facts": [{"label": "System columns", "value": "ctid"}], "related": [{"url": "/docs/10/ddl-system-columns.html", "label": "Section 5.4"}], "release": {"ref": "PostgreSQL 10.23 Documentation", "label": "10.23", "major": "10", "channel": "historical", "revision": "92d3c4a6201e06b2aea6dabfa4867cf6d1b2f66c2eb53b77ed08646b3068c291"}, "sources": [{"url": "/docs/10/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 10.23 Documentation", "sha256": "92d3c4a6201e06b2aea6dabfa4867cf6d1b2f66c2eb53b77ed08646b3068c291"}, {"url": "https://www.postgresql.org/docs/10/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 10 online manual"}], "sections": [], "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."]}, "11": {"facts": [{"label": "System columns", "value": "ctid"}], "related": [{"url": "/docs/11/ddl-system-columns.html", "label": "Section 5.4"}], "release": {"ref": "PostgreSQL 11.22 Documentation", "label": "11.22", "major": "11", "channel": "historical", "revision": "a1cc37e5ce5c2d09ce06539704c618a2d418f54eaaa35365e8c547d2aaa06311"}, "sources": [{"url": "/docs/11/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 11.22 Documentation", "sha256": "a1cc37e5ce5c2d09ce06539704c618a2d418f54eaaa35365e8c547d2aaa06311"}, {"url": "https://www.postgresql.org/docs/11/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 11 online manual"}], "sections": [], "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."]}, "12": {"facts": [{"label": "System columns", "value": "ctid"}], "related": [{"url": "/docs/12/ddl-system-columns.html", "label": "Section 5.5"}], "release": {"ref": "PostgreSQL 12.22 Documentation", "label": "12.22", "major": "12", "channel": "historical", "revision": "5675d9e3b694f46538248a1a9f533609078817a7b6d469c53533973cbfaecc8c"}, "sources": [{"url": "/docs/12/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 12.22 Documentation", "sha256": "5675d9e3b694f46538248a1a9f533609078817a7b6d469c53533973cbfaecc8c"}, {"url": "https://www.postgresql.org/docs/12/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 12 online manual"}], "sections": [], "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."]}, "13": {"facts": [{"label": "System columns", "value": "ctid"}], "related": [{"url": "/docs/13/ddl-system-columns.html", "label": "Section 5.5"}], "release": {"ref": "PostgreSQL 13.23 Documentation", "label": "13.23", "major": "13", "channel": "historical", "revision": "e8d8a34f63902cffef02459d02c2eefdf066463f9cb979c0b0b70f6659ff2bf0"}, "sources": [{"url": "/docs/13/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 13.23 Documentation", "sha256": "e8d8a34f63902cffef02459d02c2eefdf066463f9cb979c0b0b70f6659ff2bf0"}, {"url": "https://www.postgresql.org/docs/13/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 13 online manual"}], "sections": [], "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."]}, "14": {"facts": [{"label": "System columns", "value": "ctid"}], "related": [{"url": "/docs/14/ddl-system-columns.html", "label": "Section 5.5"}], "release": {"ref": "PostgreSQL 14.24 Documentation", "label": "14.24", "major": "14", "channel": "stable", "revision": "b689bc079f1ebb4b03dd138db6e1bef615d018d2cfa6f7108fab7dbdda3282bd"}, "sources": [{"url": "/docs/14/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 14.24 Documentation", "sha256": "b689bc079f1ebb4b03dd138db6e1bef615d018d2cfa6f7108fab7dbdda3282bd"}, {"url": "https://www.postgresql.org/docs/14/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 14 online manual"}], "sections": [], "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."]}, "15": {"facts": [{"label": "System columns", "value": "ctid"}], "related": [{"url": "/docs/15/ddl-system-columns.html", "label": "Section 5.5"}], "release": {"ref": "PostgreSQL 15.19 Documentation", "label": "15.19", "major": "15", "channel": "stable", "revision": "f10a38f34aecafe53113185b7e56d667b2d7d33905acde2aeef4a6fec76ff9d6"}, "sources": [{"url": "/docs/15/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 15.19 Documentation", "sha256": "f10a38f34aecafe53113185b7e56d667b2d7d33905acde2aeef4a6fec76ff9d6"}, {"url": "https://www.postgresql.org/docs/15/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 15 online manual"}], "sections": [], "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."]}, "16": {"facts": [{"label": "System columns", "value": "ctid"}], "related": [{"url": "/docs/16/ddl-system-columns.html", "label": "Section 5.5"}], "release": {"ref": "PostgreSQL 16.15 Documentation", "label": "16.15", "major": "16", "channel": "stable", "revision": "24d2f393c5bcc7ff47d33e9a61479d00dcc99825ae296491771e340391f24384"}, "sources": [{"url": "/docs/16/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 16.15 Documentation", "sha256": "24d2f393c5bcc7ff47d33e9a61479d00dcc99825ae296491771e340391f24384"}, {"url": "https://www.postgresql.org/docs/16/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 16 online manual"}], "sections": [], "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."]}, "17": {"facts": [{"label": "System columns", "value": "ctid"}], "related": [{"url": "/docs/17/ddl-system-columns.html", "label": "Section 5.6"}], "release": {"ref": "PostgreSQL 17.11 Documentation", "label": "17.11", "major": "17", "channel": "stable", "revision": "f58cc823839afa25edb5df244b0a27ad24aa1d62d2d14870e9117eda6f619a74"}, "sources": [{"url": "/docs/17/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 17.11 Documentation", "sha256": "f58cc823839afa25edb5df244b0a27ad24aa1d62d2d14870e9117eda6f619a74"}, {"url": "https://www.postgresql.org/docs/17/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 17 online manual"}], "sections": [], "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."]}, "18": {"facts": [{"label": "System columns", "value": "ctid"}], "related": [{"url": "/docs/18/ddl-system-columns.html", "label": "Section 5.6"}], "release": {"ref": "PostgreSQL 18.6 Documentation", "label": "18.6", "major": "18", "channel": "stable", "revision": "8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38"}, "sources": [{"url": "/docs/18/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 18.6 Documentation", "sha256": "8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38"}, {"url": "https://www.postgresql.org/docs/18/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 18 online manual"}], "sections": [], "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."]}, "19": {"facts": [{"label": "System columns", "value": "ctid"}], "related": [{"url": "/docs/19/ddl-system-columns.html", "label": "Section 5.6"}], "release": {"ref": "PostgreSQL 19beta4 Documentation", "label": "19beta4", "major": "19", "channel": "preview", "revision": "1985075ff3a6bdd8f41bf558847d8707b87c3103aff3c86ad4b627ac7f2d3756"}, "sources": [{"url": "/docs/19/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 19beta4 Documentation", "sha256": "1985075ff3a6bdd8f41bf558847d8707b87c3103aff3c86ad4b627ac7f2d3756"}, {"url": "https://www.postgresql.org/docs/19/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 19 online manual"}], "sections": [], "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."]}, "20": {"facts": [{"label": "System columns", "value": "ctid"}], "related": [{"url": "/docs/devel/ddl-system-columns.html", "label": "Section 5.6"}], "release": {"ref": "PostgreSQL 20devel Documentation", "label": "20devel", "major": "20", "channel": "devel", "revision": "dc75e7ebcf3d74dccbbc22ff10acdddc868b64becff49460d7f6ae89659f8be4"}, "sources": [{"url": "/docs/devel/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 20devel Documentation", "sha256": "dc75e7ebcf3d74dccbbc22ff10acdddc868b64becff49460d7f6ae89659f8be4"}, {"url": "https://www.postgresql.org/docs/devel/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL devel online manual"}], "sections": [], "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."]}}, "content_hash": "a9a261dad74c2af850943403404b48ff885eda3167ab7d6e53f753fe5e5dfcb2", "imported_at": "2026-09-27T09:57:59.125"}, "snapshot": {"facts": [{"label": "System columns", "value": "ctid"}], "related": [{"url": "/docs/18/ddl-system-columns.html", "label": "Section 5.6"}], "release": {"ref": "PostgreSQL 18.6 Documentation", "label": "18.6", "major": "18", "channel": "stable", "revision": "8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38"}, "sources": [{"url": "/docs/18/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 18.6 Documentation", "sha256": "8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38"}, {"url": "https://www.postgresql.org/docs/18/datatype-oid.html#DATATYPE-OID", "label": "PostgreSQL 18 online manual"}], "sections": [], "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."]}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}