SPI_FNAME(3)

🎀 SPI_FNAME(3) 🎀

okay bestie, this one is straight from the PostgreSQL 16.15 Documentation — it’s giving “find the column name” energy and it’s lowkey iconic.

🌸 NAME 🌸

SPI_fname — determine the column name for the specified column number.

✨ SYNOPSIS ✨

char * SPI_fname(TupleDesc rowdesc, int colnumber)

💖 DESCRIPTION 💖

SPI_fname returns a copy of the column name of the specified column. (You can use pfree to release the copy of the name when you don’t need it anymore.) Obsessed, honestly.

🫶 ARGUMENTS 🫶

• TupleDesc rowdesc — input row description, fr fr.
• int colnumber — column number (count starts at 1). Not zero, bestie — the count starts at one.

👑 RETURN VALUE 👑

The column name; NULL if colnumber is out of range. On error, SPI_result is set to SPI_ERROR_NOATTRIBUTE.

That’s the whole vibe, bestie 💅 — source/version is PostgreSQL 16.15, dated 2026. Mwah, go slay your column-name lookup. 🎀