SPI_GETRELNAME(3)

✨ SPI_GETRELNAME ✨

okay bestie, welcome to section 3 of the PostgreSQL 18.6 docs 💖 this one's a lil function called SPI_getrelname, and it's giving "tell me her name" energy. no cap.

---

🌸 NAME 🌸

SPI_getrelname — bestie, this hands you back the name of the specified relation 🎀

---

🦋 SYNOPSIS 🦋

char * SPI_getrelname(Relation rel)

---

💅 DESCRIPTION 💅

so here's the tea: SPI_getrelname returns a copy of the name of the relation you pass in. like, an actual copy, not just a pointer to the original, which is so thoughtful of it honestly 🫶

and because it's a copy, you own it — so when you're done with it and don't need the name anymore, you can pfree that copy to release it. clean up after yourself, queen 👑

---

🌈 ARGUMENTS 🌈

• Relation rel — the input relation. that's the one whose name you're tryna get 💜

---

⭐ RETURN VALUE ⭐

the name of the specified relation. literally that. no plot twist 💖

---

fr fr, don't forget the pfree when you're done — that copy isn't gonna free itself and your memory ain't infinite, iykyk 😭

---

and that's the whole page, bestie — written up in the PostgreSQL 18.6 docs, dated 2026, section 3, and it ate 💅✨