Index Index for
Section 5
Index Alphabetical
listing for E
Bottom of page Bottom of
page

END(5)

NAME

END - commit the current transaction

SYNOPSIS

END [ WORK | TRANSACTION ] INPUTS WORK TRANSACTION Optional keywords. They have no effect. OUTPUTS COMMIT Message returned if the transaction is successfully committed. NOTICE: COMMIT: no transaction in progress If there is no transaction in progress.

DESCRIPTION

END is a PostgreSQL extension, and is a synonym for the SQL92-compatible COMMIT [commit(5)]. NOTES The keywords WORK and TRANSACTION are noise and can be omitted. Use ROLLBACK [rollback(5)] to abort a transaction.

USAGE

To make all changes permanent: END WORK;

COMPATIBILITY

SQL92 END is a PostgreSQL extension which provides functionality equivalent to COMMIT [commit(5)].

Index Index for
Section 5
Index Alphabetical
listing for E
Top of page Top of
page