COMMIT
PostgreSQL User's GuidePrevNextCOMMITName COMMIT
— Commits the current transaction
COMMIT [ WORK | TRANSACTION ]
Inputs
None
Outputs
ENDMessage returned if the transaction is successfully committed.
NOTICE EndTransactionBlock and not inprogress/abort stateIf there is no transaction in progress.
Description
COMMIT commits the current transaction. All
changes made by the transaction become visible to others
and are guaranteed to be durable if a crash occurs.
Notes
The keywords WORK and TRANSACTION are noise and can be omitted.
Use the ROLLBACK statement to abort a transaction.
Usage
To make all changes permanent:
COMMIT WORK;
Compatibility SQL92
Full compatibility.
PrevHomeNextCLUSTERUpCOPY
Wyszukiwarka