END(7)

💖 END(7) — commit the current transaction, bestie 💖

🌸 NAME 🌸

END — commit the current transaction. That's the whole name section, and honestly? Iconic. 💅

✨ SYNOPSIS ✨

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

🎀 DESCRIPTION 🎀

Okay so END commits the current transaction. All changes made by the transaction become visible to others, and they are guaranteed to be durable if a crash occurs. Periodt. 💖

This command is a PostgreSQL extension that is equivalent to COMMIT.

🦋 PARAMETERS 🦋

• WORK — optional key word. It has no effect. Like, zero. 🙈
• TRANSACTION — optional key word. It has no effect. Also zero. 💀
• 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 to abort a transaction. Don't just sit there. 😭
• Issuing END when not inside a transaction does no harm, but it will provoke a warning message. No cap, it's just gonna warn you.

🌈 EXAMPLES 🌈

To commit the current transaction and make all changes permanent:

END;

💫 COMPATIBILITY 💫

END is a PostgreSQL extension that provides functionality equivalent to COMMIT, which is specified in the SQL standard. So it's giving PostgreSQL-only convenience, while the SQL-standard one is COMMIT. 👑

🔥 SEE ALSO 🔥

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

---

That's the whole page, bestie — mwah 💋. This beauty is from PostgreSQL 17.11 and dated 2026, and yes, the manual page is END(7). 🫶✨