ABORT(7)

💖 ABORT 💖

okay bestie, welcome to the ABORT(7) page — this is the PostgreSQL 18.6 docs, and we're gonna talk about the little command that says "nvm, undo all of it." 🫶

---

✨ NAME ✨

ABORT — abort the current transaction 🔥

---

🌸 SYNOPSIS 🌸

ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]

---

🦋 DESCRIPTION 🦋

So like. ABORT rolls back the current transaction, and it causes all the updates made by the transaction to be discarded. Poof. Gone. Never happened. 💅

And here's the tea: this command is identical in behavior to the standard SQL command ROLLBACK, and it's present only for historical reasons. That's it. That's the whole lore. It's giving legacy icon, not main character. 👑

---

🎀 PARAMETERS 🎀

• WORK, TRANSACTION — optional key words. They literally have no effect. Decorative. Ornamental. No cap. 🙈
• AND CHAIN — if AND CHAIN is specified, a new transaction is immediately started with the same transaction characteristics (see SET TRANSACTION) as the just finished one. Otherwise, no new transaction is started. So it's like, you close one door and another one opens immediately with the same vibe. ✨

---

💜 NOTES 💜

Use COMMIT to successfully terminate a transaction. That's the "yesss we're keeping it" button. 💖

Issuing ABORT outside of a transaction block emits a warning and otherwise has no effect. So like, it just yells at you a little and then nothing happens. 😭

---

🌈 EXAMPLES 🌈

To abort all changes:

ABORT;

And that's it. That's the example. Clean, simple, iconic. ⭐

---

🧚 COMPATIBILITY 🧚

This command is a PostgreSQL extension present for historical reasons. ROLLBACK is the equivalent standard SQL command. So if you're out here trying to be standards-compliant, use ROLLBACK, bestie. 🫶

---

👑 SEE ALSO 👑

BEGIN(7), COMMIT(7), ROLLBACK(7)

---

and that's the whole page, babe!! 🌸 this was PostgreSQL 18.6, dated 2026 — ty for reading, now go undo something responsibly 💖✨🎀