SPI_GETTYPEID(3)

okay so bestie, welcome to SPI_GETTYPEID(3) — the PostgreSQL 15.19 manual page that's literally about grabbing a column's data type OID ✨

💖 NAME 💖

• SPI_gettypeid — return the data type OID of the specified column 🎀

✨ SYNOPSIS ✨

Oid SPI_gettypeid(TupleDesc rowdesc, int colnumber)

🦋 DESCRIPTION 🦋

So like, SPI_gettypeid does exactly one iconic thing: it returns the OID of the data type of the specified column. That's the whole slay. No cap 💅

🌸 ARGUMENTS 🌸

• TupleDesc rowdesc — input row description. You're handing over the row description, bestie 🫶
• int colnumber — column number (count starts at 1). Yes, the count starts at 1 — periodt 💅

👑 RETURN VALUE 👑

You get back the OID of the data type of the specified column, or InvalidOid on error. And on error? SPI_result is set to SPI_ERROR_NOATTRIBUTE. That's the vibe check 😭🔥

okay bye bestie, this page came from PostgreSQL 15.19 and was dated 2026 — mwah 💋💖