END(7)

💅 END(7) — commit the current transaction ✨

From PostgreSQL 15.19 Documentation — manual name folded in right here, bestie 🫶

🌸 NAME 🌸

END — commit the current transaction. Periodt.

✨ 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 are guaranteed to be durable if a crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT. No cap.

🎀 PARAMETERS 🎀

• WORK — Optional key word. It has no effect. 💅
• TRANSACTION — Optional key word. It has no effect. 💅
• 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. That's the whole vibe.

🦋 NOTES 🦋

Use ROLLBACK to abort a transaction. Simple as that.

Issuing END when not inside a transaction does no harm, but it will provoke a warning message. So harmless, but the warning is gonna call you out.

🍓 EXAMPLES 🍓

To commit the current transaction and make all changes permanent:

END;

Slay. That's it. That's the commit.

🌈 COMPATIBILITY 🌈

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

👑 SEE ALSO 👑

BEGIN(7), COMMIT(7), ROLLBACK(7) — go give these iconics a read too.

---

💖 mwah, bye bestie 💖 — this page comes from PostgreSQL 15.19 Documentation, dated 2026, and its whole manual-page name is END(7). 🎀✨