Your company here ā€” click to reach over 10,000 unique daily visitors

SPI_copytuple - Man Page

make a copy of a row in the upper executor context


HeapTuple SPI_copytuple(HeapTuple row)


SPI_copytuple makes a copy of a row in the upper executor context. This is normally used to return a modified row from a trigger. In a function declared to return a composite type, use SPI_returntuple instead.

This function can only be used while connected to SPI. Otherwise, it returns NULL and sets SPI_result to SPI_ERROR_UNCONNECTED.


HeapTuple row

row to be copied

Return Value

the copied row, or NULL on error (see SPI_result for an error indication)


2023 PostgreSQL 15.5 Documentation