Book Contents

Book Index

Next Topic

Home

COMMIT

The COMMIT command ends the current transaction and makes all changes that occurred during the transaction permanent and visible to other users.

Syntax

COMMIT [ WORK | TRANSACTION ]

Semantics

 

WORK

TRANSACTION

have no effect; they are optional keywords for readability.

SQL Language References

PostgreSQL 8.0.12 Documentation

BNF Grammar for SQL-99