SPI_GETTYPE(3)

✨ NAME ✨

okay so welcome to SPI_gettype, bestie — this is the PostgreSQL 14.24 Documentation page for it, section 3 (SPI_GETTYPE(3), iykyk), and its whole thing is literally to return the data type name of the specified column. no cap, that's the assignment. 💅

🌸 SYNOPSIS 🌸

char * SPI_gettype(TupleDesc rowdesc, int colnumber)

🦋 DESCRIPTION 🦋

SPI_gettype hands you a copy of the data type name for the column you picked. that's it, that's the tea. ☕ when you're done with the copy of the name and don't need it anymore, you can use pfree to release it. (yes bestie, free your memory, it's giving responsible icon behavior. 💖)

🎀 ARGUMENTS 🎀

• TupleDesc rowdesc — the input row description, aka the row's little info card. 🪪
• int colnumber — the column number. count starts at 1, not 0 — that's the rule, fr fr. 🔢

👑 RETURN VALUE 👑

you get the data type name of the specified column, or NULL on error. 😭 and on error, SPI_result is set to SPI_ERROR_NOATTRIBUTE — that's the exact code, periodt.

💖 later, bestie — this page is from PostgreSQL 14.24, dated 2026. mwah! 💖