Commits the current transaction.
COMMIT [ WORK ]
You can use the Commit command to commit the current transaction. All changes that are made by the transaction are visible to others and retained even if an exception occurs.
When you run the COMMIT command in a PL/pgSQL procedure, an error occurs if an Oracle-style SPL stored procedure exists on the runtime stack.
|WORK||Optional. This keyword has no effect.|
Commit the current transaction and permanently store the changes: