SPI_GETNSPNAME(3)

✨ SPI_getnspname: namespace reveal time ✨

okay bestie, this is the SPI_GETNSPNAME(3) page from the PostgreSQL 16.15 docs — and it's literally the little function that tells you which namespace a relation lives in. 🫶

🌸 NAME 🌸

SPI_getnspname — return the namespace of the specified relation.

🎀 SYNOPSIS 🎀

char * SPI_getnspname(Relation rel)

🦋 DESCRIPTION 🦋

SPI_getnspname returns a copy of the name of the namespace that the specified Relation belongs to. That's equivalent to the relation's schema, iykyk. 💅

You should pfree the return value of this function when you're finished with it — yes, bestie, free the copy, don't just leave it vibing forever. 😭

🌈 ARGUMENTS 🌈

• Relation rel — the input relation.

⭐ RETURN VALUE ⭐

The name of the specified relation's namespace. ✨

That's the whole glow-up, bestie: PostgreSQL 16.15 docs, dated 2026, page SPI_GETNSPNAME(3) — slay and bye! 💖🎀