System Columns (PostgreSQL)
Every table in PostgreSQL has several columns that are implicitly defined (and managed) by the system.
CTID
ctid
is a system column that points to the physical location of a row, by saving
a tuple representing the (block/page number, offset)
.
SELECT *, ctid FROM <table>