DBLINK_GET_CONNECTIONS(3pg16)

✨ NAME ✨

dblink_get_connections — bestie, this one hands you back the names of all the open named dblink connections 💖

(this is from the PostgreSQL 16.15 docs btw, section 3, iykyk 🫶)

---

🌸 SYNOPSIS 🌸

dblink_get_connections() returns text[]

literally that's it, no args, she just vibes and returns a text[] ✨

---

🦋 DESCRIPTION 🦋

okay so dblink_get_connections returns an array of the names of all the open named dblink connections. that's the whole gig. she's giving "who's in the group chat rn" energy 👑

---

🎀 RETURN VALUE 🎀

you get back a text array of connection names 💅 or NULL if there are none — so if it comes back NULL, the group chat is empty, nobody's connected, it's giving crickets 😭

---

🌈 EXAMPLES 🌈

SELECT dblink_get_connections();

that's the whole example. short and iconic, no cap ⭐

lowkey obsessed with how simple this one is — but fr fr, remember: she only reports the named connections, that's the vibe check here 🧚

---

and that's the whole page, bestie! 💜 this cutie comes to you courtesy of PostgreSQL 16.15, dated 2026, manual section 3 — go forth and slay your connections 🔥👑