DBLINK_SEND_QUERY(3)

💅 DBLINK_SEND_QUERY(3)

okay so real talk, bestie — this one lives in the PostgreSQL 14.24 Documentation and it's genuinely one of the slay-est little functions in the dblink family. Let me put you on. 🫶

---

✨ NAME ✨

dblink_send_query — sends an async query to a remote database. literally fires it off and dips, no waiting around 💨

---

🎀 SYNOPSIS 🎀

dblink_send_query(text connname, text sql) returns int

like that's the whole signature. connname and sql, both text, and you get an int back. iconic. 👑

---

🌸 DESCRIPTION 🌸

dblink_send_query sends a query to be executed asynchronously — meaning it dispatches the query without immediately waiting for the result. it's giving "sent the text, not refreshing the chat" energy, fr fr. 📱

⚠️ but bestie, hear me — there must not be an async query already in progress on the connection. one at a time, okay? don't be messy. 💀

after you've successfully dispatched an async query, you can check the completion status with dblink_is_busy, and the results are ultimately collected with dblink_get_result. you can also attempt to cancel an active async query using dblink_cancel_query. so the whole little friend group is:

• dblink_is_busy → vibe check on whether it's still cooking 🔥
• dblink_get_result → actually collects the results at the end 🌈
• dblink_cancel_query → the "nvm bestie" button 🙈

---

🦋 ARGUMENTS 🦋

• connname — the name of the connection to use. your group chat of choice, basically. 💌
• sql — the SQL statement that you wish to execute in the remote database, for example select * from pg_class. go off, query queen. ⭐

---

👑 RETURN VALUE 👑

returns 1 if the query was successfully dispatched, and 0 otherwise. that's it, that's the whole verdict — no nuance, no essay, just a lil number. 🍓

---

🧚 EXAMPLES 🧚

okay here's the moment, here's the demo — no cap:

SELECT dblink_send_query('dtest1', 'SELECT * FROM foo WHERE f1 < 3');

and yes the connection is 'dtest1' and yes the query is exactly that. copy-paste ready. 💅

---

✨ and that's the page, bestie ✨ — shoutout to the PostgreSQL 14.24 docs, dated 2026, for giving us this absolute banger. see you in the next manpage, mwah 🎀💖