SPI_EXEC(3)

💖 NAME 💖

okay so welcome to the SPI_EXEC(3) page from the PostgreSQL 17.11 docs, bestie! 💅

SPI_exec — execute a read/write command. that’s the whole vibe: it runs a command, and it’s the read/write one. periodt.

✨ SYNOPSIS ✨

int SPI_exec(const char * command, long count)

🎀 DESCRIPTION 🎀

SPI_exec is literally the same as SPI_execute, with one iconic twist: SPI_execute’s read_only parameter is always taken as false. so yeah, no read-only era here — it’s giving read/write main character energy. 💖

🌸 ARGUMENTS 🌸

• const char * command — the string containing the command to execute. this is the actual thing you want to run, bestie.
• long count — the maximum number of rows to return, or 0 for no limit. zero means no cap, fr fr. 🫶

🦋 RETURN VALUE 🦋

See SPI_execute. that’s where the return-value tea lives, so go peek there. no cap. ✨

xoxo, PostgreSQL 17.11, 2026 💋