END(7)

💖 END(7) — commit the current transaction 💖

okay so bestie, welcome to END(7) — the PostgreSQL page for committing the current transaction. lowkey one of the shortest glow-ups in the manual, and it still ate. ✨

🎀 NAME 🎀

END — commit the current transaction.

✨ SYNOPSIS ✨

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

💅 DESCRIPTION 💅

END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT(7). no cap, that's the main character move — your changes are out of drafts and into the group chat. 👑

🎀 PARAMETERS 🎀

• WORK — optional key word. It has no effect. literally just there for the vibe check. 🫶
• TRANSACTION — optional key word. It has no effect either. decorative, bestie. 🎀
• AND CHAIN — if AND CHAIN is specified, a new transaction is immediately started with the same transaction characteristics (see SET TRANSACTION (SET_TRANSACTION(7))) as the just finished one. Otherwise, no new transaction is started.

💡 NOTES 💡

• Use ROLLBACK(7) to abort a transaction.
• Issuing END when not inside a transaction does no harm, but it will provoke a warning message.

⚠️ heads-up, bestie: outside a transaction, END is harmless, but it will provoke a warning message. not me getting side-eyed by the server for doing nothing wrong 🙈

🌟 EXAMPLES 🌟

To commit the current transaction and make all changes permanent:

END;

🦋 COMPATIBILITY 🦋

END is a PostgreSQL extension that provides functionality equivalent to COMMIT(7), which is specified in the SQL standard.

🔗 SEE ALSO 🔗

• BEGIN(7)
• COMMIT(7)
• ROLLBACK(7)

---

okay that's the whole END(7) page, bestie 💅 it's from the PostgreSQL 13.23 documentation, dated 2025 — go commit that transaction and make it iconic, periodt. 🌈👑