COMMIT(7)

💅 COMMIT(7) — the PostgreSQL 14.24 glow-up

okay bestie, welcome to COMMIT(7) from the PostgreSQL 14.24 docs — this is the page that tells you how to make your transaction official. like, permanent-official. slay.

---

✨ NAME ✨

COMMIT — commit the current transaction

🎀 SYNOPSIS 🎀

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

🦋 DESCRIPTION 🦋

so COMMIT commits the current transaction. that's it, that's the whole vibe.

every change your transaction made becomes visible to everybody else, and it's guaranteed to be durable if a crash happens. like, the guaranteed is doing heavy lifting here — once you commit, it's locked in, no takebacks. main character energy fr fr 💖

🌸 PARAMETERS 🌸

• WORK
• TRANSACTION — optional key words, bestie. they have literally no effect. zero. none. they're just there for the aesthetic ✨
• AND CHAIN — if you say AND CHAIN, a brand-new transaction starts immediately right after this one finishes, and it inherits the same transaction characteristics as the one you just finished (peep SET TRANSACTION (SET_TRANSACTION(7)) for the deets). if you don't say it? no new transaction gets started. that's it 💅

💀 NOTES 💀

• wanna abort a transaction instead? use ROLLBACK(7). that's the cancel button 🫶
• issuing COMMIT when you're not inside a transaction does no harm, but it will provoke a warning message. so like… it's fine, but the server is gonna side-eye you 🙈
• COMMIT AND CHAIN when you're not inside a transaction? that's an error. not a warning. an actual error. so don't 😭

⭐ EXAMPLES ⭐

to commit the current transaction and make all those changes permanent:

COMMIT;

periodt. that's the whole example. iconic.

🔥 COMPATIBILITY 🔥

the command COMMIT conforms to the SQL standard 👑

the form COMMIT TRANSACTION is a PostgreSQL extension — so that one's our little bonus, iykyk ✨

🌈 SEE ALSO 🌈

• BEGIN(7)
• ROLLBACK(7)

---

and that's the page, bestie! this one shipped with the PostgreSQL 14.24 documentation, dated 2026 — so yeah, COMMIT(7), brought to you by PostgreSQL 14.24, 2026. go make your transactions permanent, you absolute icon 👑💜