Postgresql Pseudo-columns; CTID
Oct 22, 2023 · 7 min read · Postgres CTID is an internal table column identifying how Postgres stores table data physically on the disc. It comes as two comma-separated numbers, e.g. (0, 1), 0 here serving as the page number, and 1 is the row's location on the page. Let's estab...
Join discussion