DBLINK_DISCONNECT(3)

🦋 dblink_disconnect — DBLINK_DISCONNECT(3) 🦋

okay so bestie, this is the page for dblink_disconnect from the PostgreSQL 13.23 docs. It's giving “close that connection, queen” energy, and honestly? Iconic. 💅

---

🌸 NAME 🌸

dblink_disconnect — closes a persistent connection to a remote database. That's the whole vibe. No cap. ✨

---

✨ SYNOPSIS ✨

dblink_disconnect() returns text
dblink_disconnect(text connname) returns text

Two forms, both returning text, both ready to say bye-bye to a connection. 🫶

---

💖 DESCRIPTION 💖

okay so dblink_disconnect() closes a connection previously opened by dblink_connect(). The form with no arguments closes an unnamed connection. Literally just closing the door behind you. 🚪✨

---

🎀 ARGUMENTS 🎀

• connname — the name of a named connection to be closed. That's it. That's the argument. Slay. 💅

---

⭐ RETURN VALUE ⭐

Returns status, which is always OK (since any error causes the function to throw an error instead of returning). So bestie, it's OK or it throws — no mysterious in-between behavior. periodt. 😭

---

🌈 EXAMPLES 🌈

No-argument form, unnamed connection, clean exit:

SELECT dblink_disconnect();
 dblink_disconnect
-------------------
 OK
(1 row)

Named-connection form, same energy:

SELECT dblink_disconnect('myconn');
 dblink_disconnect
-------------------
 OK
(1 row)

Both ate. Both returned OK. We love a consistent queen. 👑

---

okay that's the whole page, bestie — source/version: PostgreSQL 13.23, date: 2025. bye-bye connection, hello closure. 💖🦋