DBLINK_DISCONNECT(3)

πŸ“¦ version 14.24, in opensuse-leap 16.0

✨ NAME ✨

okay so bestie, welcome to the DBLINK_DISCONNECT(3) manual page β€” the main character here is dblink_disconnect, and it literally closes a persistent connection to a remote database. no cap. 🫢


🌸 SYNOPSIS 🌸

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

πŸ¦‹ DESCRIPTION πŸ¦‹

dblink_disconnect() closes a connection that was previously opened by dblink_connect(). the form with no arguments closes an unnamed connection. that's the vibe. πŸ’…

πŸŽ€ ARGUMENTS πŸŽ€

  • connname β€” the name of a named connection to be closed. simple as that. ✨

πŸ’– RETURN VALUE πŸ’–

it returns status, and that status is always OK β€” because any error causes the function to throw an error instead of returning. so yeah, no sneaky little error value coming back. 😭

πŸ”₯ EXAMPLES πŸ”₯

first up, the no-arguments form:

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

then with a named connection:

           SELECT dblink_disconnect('myconn');
            dblink_disconnect
           -------------------
            OK
           (1 row)
bestie note: those examples are shown exactly as they appear in the original. no editing the output, no adding extra rows. πŸ™ˆ

mwah πŸ’‹ β€” this is from PostgreSQL 14.24, dated 2026, and that's the whole DBLINK_DISCONNECT(3) page. slay. πŸ‘‘

πŸ“¦ where this page comes from