END

Name

END -- Ends the current transaction block and finalizes its modifications.

Synopsis

END [ WORK | TRANSACTION ]

Parameters

WORK | TRANSACTION

A pair of optional noise keywords. They can be ignored, or used to make your SQL more readable.

Results

COMMIT

The message returned when a transaction is successfully committed.

NOTICE: COMMIT: no transaction in progress

The notice returned if there is no transaction in progress for the END command to end.

Description

The END command is a synonym for COMMIT. Use it to end transactions the same way you would use the COMMIT command.

Example

The following example demonstrates how to commit a transaction using the END command:

booktown=# END WORK;
COMMIT