Provide the Difference

[Rahulbatra]

I want to know whether there is any difference in OID and CTID in PostgreSQL. If so what is it. If someone could provide example it would be great.

[Ralph]

CTIDs are used to identify specific physical rows with block and offset values. They are used by index entries to point to physical rows. Every row that is created in PostgreSQL gets an OID.

[rachelle]

I want to know whether OID and CTIDs are unique for each row and also how many byte integers are assigned for OID and CTID.

[sammy]

Each row gets a unique a OID when a table is created WITH OIDS. OIDs are automatically assigned unique 4-byte integers that are unique across the entire installation. CTIDs change after rows are modified or reloaded.