END(7)

💖 NAME 💖

END — commit the current transaction. yes bestie, this is the END(7) page 🫶

✨ SYNOPSIS ✨

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

🌸 DESCRIPTION 🌸

okay so END commits the current transaction. Every change made by that transaction becomes visible to others, and it's guaranteed to be durable if a crash occurs — that's the whole vibe. This command is a PostgreSQL extension that is equivalent to COMMIT. slay 💅

🎀 PARAMETERS 🎀

• WORK — optional key word. It has no effect. literally just there for the aesthetic ✨
• TRANSACTION — optional key word. Also no effect. matching energy 🫶
• 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. 💖

🚨 Issuing END when you're not inside a transaction does no harm, but it will provoke a warning message. no cap.

🌈 EXAMPLES 🌈

To commit the current transaction and make all changes permanent:

END;

periodt. 💅

⭐ 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)

---

mwah 💋 — this page is from PostgreSQL 16.15, dated 2026, and it's the END(7) manual page. periodt ✨