Re: HeapTuple layout

Michael Klatt <mdklatt(at)ou(dot)edu> writes:
> Is a HeapTuple for a particular table guaranteed to have the same layout
> (order and number of attributes) as that table?

Define what you mean by "for a table". If it's actually intended to be
stored in the table then it had better have the right layout. A tuple
read from a table will have the expected layout but may be missing
columns at the end (in case it hasn't been updated since an ALTER TABLE
ADD COLUMN command). The standard tuple access routines treat this case
as meaning that the missing columns are NULLs.

> Also, is a HeapTuple used to store the tuples in a PGresult?

No, HeapTuples are only used inside the backend.

regards, tom lane