CLOSE(7)

💖 CLOSE(7) — the PostgreSQL manual page, bestie edition 💖

okay so this is the CLOSE page from the PostgreSQL 18.6 Documentation, and we're about to close some cursors like it's the end of a group chat 💅

---

✨ NAME ✨

CLOSE — close a cursor 🎀

---

🌸 SYNOPSIS 🌸

CLOSE { name | ALL }

literally just that. two options. pick one. slay.</p紫色>

---

🦋 DESCRIPTION 🦋

So CLOSE frees the resources associated with an open cursor. Once a cursor is closed, no subsequent operations are allowed on it — like, it's done, it's over, it has left the building. 🚪 And fr fr, you should close a cursor when you no longer need it. It's giving basic cursor hygiene. ✨

Now here's the tea on implicit closing, because Postgres does some of it for you:

• Every non-holdable open cursor is implicitly closed when a transaction is terminated by COMMIT or ROLLBACK. 🫶
• A holdable cursor is implicitly closed if the transaction that created it aborts via ROLLBACK. 💀
• If the creating transaction successfully commits, the holdable cursor remains open until an explicit CLOSE is executed, or the client disconnects. 👑

---

🎀 PARAMETERS 🎀

• name — the name of an open cursor to close. you gotta name it, bestie, no anonymous cursors here 🙈
• ALL — close all open cursors. every single one. the whole squad. 🌈

---

💅 NOTES 💅

Important lore drop: PostgreSQL does not have an explicit OPEN cursor statement. A cursor is considered open when it is declared. So use the DECLARE statement to declare a cursor. that's the whole vibe, iykyk 🧚

You can see all available cursors by querying the pg_cursors system view. 👀 go look, they're all just sitting there.

⚠️ caveat alert: if a cursor is closed after a savepoint which is later rolled back, the CLOSE is not rolled back. That is, the cursor remains closed. no takebacks. 💀

---

⭐ EXAMPLES ⭐

Close the cursor liahona:

CLOSE liahona;

ate. no crumbs. ✨

---

👑 COMPATIBILITY 👑

CLOSE is fully conforming with the SQL standard 🎉 — icon behavior, honestly. But heads up: CLOSE ALL is a PostgreSQL extension. so if you take that one to another database, it might not know what you're talking about. 🙈

---

🌈 SEE ALSO 🌈

• DECLARE(7)
• FETCH(7)
• MOVE(7)

go read those next, bestie, they're the whole friend group 🫶

---

and that's the page!! this was the PostgreSQL 18.6 docs, dated 2026 💜 tysm for reading, now go close those cursors before they pile up in your session like unread messages 💖✨🎀