COMMIT(7)

📦
version 18.6 · 20 versions
, in alpine 3.23, alpine 3.24, arch rolling, fedora 43, fedora 44, nixos 26.05, ubuntu resolute, ubuntu stonking

💖 COMMIT(7) 💖

okay bestie, welcome to the COMMIT page — it's the PostgreSQL 18.6 documentation moment, and we're gonna talk about the single most satisfying button in all of SQL. no cap. 🫶

✨ NAME ✨

COMMIT — commit the current transaction 💅

🌸 SYNOPSIS 🌸

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

🦋 DESCRIPTION 🦋

COMMIT 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. like... it's locked in. periodt. 👑

🎀 PARAMETERS 🎀

  • WORK
  • TRANSACTION

optional key words, bestie. they have no effect. literally none. they're just there vibing. 🫧

  • 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. so it's giving "and another one" energy 🔥

💜 NOTES 💜

use ROLLBACK(7) to abort a transaction. that's the other button. choose wisely. 😭

issuing COMMIT when not inside a transaction does no harm, but it will provoke a warning message. so like, rude of you, but not fatal. COMMIT AND CHAIN when not inside a transaction, though? that's an error. not a vibe. 💀

🌈 EXAMPLES 🌈

to commit the current transaction and make all changes permanent:

COMMIT;

slay. that's it. that's the whole thing. ✨

⭐ COMPATIBILITY ⭐

the command COMMIT conforms to the SQL standard. the form COMMIT TRANSACTION is a PostgreSQL extension. so we're standards-compliant and we have a lil bonus form. main character energy fr fr. 👑

👑 SEE ALSO 👑

BEGIN(7), ROLLBACK(7)

and that's the whole page, bestie!! this was the PostgreSQL 18.6 docs, dated 2026, and the page is COMMIT(7) — mwah, go commit something iconic 💖✨🎀

📦 where this page comes from