SPI_COPYTUPLE(3)

💖 NAME 💖

Hey bestie, this is the manual page for SPI_COPYTUPLE(3) — the little PostgreSQL helper that makes a copy of a row in the upper executor context ✨

🌸 SYNOPSIS 🌸

HeapTuple SPI_copytuple(HeapTuple row)

🦋 DESCRIPTION 🦋

Okay so 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. Noted, bestie, no cap 💅

⚠️ This function can only be used while connected to SPI. Otherwise, it returns NULL and sets SPI_result to SPI_ERROR_UNCONNECTED. So yeah — stay connected, or it's giving error vibes 😭

🎀 ARGUMENTS 🎀

• HeapTuple row — the row to be copied 🫶

⭐ RETURN VALUE ⭐

The copied row, or NULL on error — see SPI_result for an error indication 👑

That's the whole vibe, bestie — PostgreSQL 16.15, 2026, signing off 🧚💖