DBLINK_GE...NNECTIONS(3)

✨ NAME ✨

dblink_get_connections — bestie, this is the lil function that hands you back the names of every open named dblink connection. like, all of them. the whole roster. 💅

it lives in the PostgreSQL 18.6 Documentation section 3, so you already know it's a library call situation 🫶

---

🌸 SYNOPSIS 🌸

dblink_get_connections() returns text[]

no arguments, no drama, it just shows up and tells you who's there 💖

---

🦋 DESCRIPTION 🦋

okay so dblink_get_connections returns an array of the names of all open named dblink connections. that's it. that's the whole vibe. it's giving roll call at the beginning of class, except everyone on the list actually showed up and is currently connected 👑

---

🎀 RETURN VALUE 🎀

it returns a text array of connection names ✨

or NULL if there are none 😭 (yes, empty roster = NULL, not an empty array, we don't make the rules)

---

🌈 EXAMPLES 🌈

look at her go:

SELECT dblink_get_connections();

one line, iconic, does exactly what it says on the tin 💜

---

fr fr no cap: this is the "who's online rn" check for your dblink connections. screenshot it, frame it, put it in the group chat 📸

---

written up in the PostgreSQL 18.6 Documentation, dated 2026, filed under DBLINK_GE...NNECTIONS(3) — mwah, go check your connections bestie, ily, bye 💖🎀🦋✨