select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 7.0 / 6.5 / 6.4
Historical version. PostgreSQL 6.4 reached end of support in October 2003. See the current manual for supported releases.

COMMIT

Name

COMMIT — Commits the current transaction
COMMIT [ WORK | TRANSACTION ]
  

Inputs

None

Outputs

END

Message returned if the transaction is successfully committed.

NOTICE EndTransactionBlock and not inprogress/abort state

If 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.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.