DBLINK_GET_CONNECTIONS(3pg17)

💅 NAME 💅

Okay so bestie, listen up — dblink_get_connections is the function that literally hands you back the names of all the open named dblink connections. Like, every single one that's currently vibing in your session. No cap. 🌈

This is page 3 of the PostgreSQL 17.11 docs, and yes we are reading the whole thing together, grab a snack 🍓

---

✨ SYNOPSIS ✨

dblink_get_connections() returns text[]

That's the whole signature, she's simple and she slays 🎀

---

🦋 DESCRIPTION 🦋

So the way this works: dblink_get_connections returns an array — a whole lil lineup — of the names of all the open named dblink connections. That's it, that's the whole job. She's the group chat member list, but for your dblink connections 👑

---

🌸 RETURN VALUE 🌸

You get back a text array stuffed with connection names. Cute!

But lowkey important: if there are none — like, zero, nothing, an empty friend group 😭 — it returns NULL. Not an empty array, bestie. NULL. Write that down 🫶

---

🔥 EXAMPLES 🔥

Just call her, that's it:

SELECT dblink_get_connections();

Iconic. Periodt. 💜

---

fr fr, the only gotcha here is the NULL-when-empty thing — don't get caught out thinking you'll get an empty array back, because you will not 💀

---

That's the whole page, bestie — short and sweet, she ate and left no crumbs 👑 This was DBLINK_GET_CONNECTIONS(3) from the PostgreSQL 17.11 documentation, dated 2026. Go forth and query your connections ✨🧚