# COMMIT_PREPARED - commit a transaction that was earlier prepared for two... - man(7) - [phpMan]

_COMMIT_ [_PREPARED_(7)](https://www.chedong.com/phpMan.php/man/PREPARED/7/markdown)                 PostgreSQL 16.14 Documentation                 _COMMIT_ [_PREPARED_(7)](https://www.chedong.com/phpMan.php/man/PREPARED/7/markdown)

## NAME
       COMMIT_PREPARED - commit a transaction that was earlier prepared for two-phase commit

## SYNOPSIS
       COMMIT PREPARED _transaction_id_

## DESCRIPTION
       **COMMIT PREPARED **commits a transaction that is in prepared state.

## PARAMETERS
       _transaction_id_
           The transaction identifier of the transaction that is to be committed.

## NOTES
       To commit a prepared transaction, you must be either the same user that executed the
       transaction originally, or a superuser. But you do not have to be in the same session that
       executed the transaction.

       This command cannot be executed inside a transaction block. The prepared transaction is
       committed immediately.

       All currently available prepared transactions are listed in the pg_prepared_xacts system
       view.

## EXAMPLES
       Commit the transaction identified by the transaction identifier foobar:

           COMMIT PREPARED 'foobar';

## COMPATIBILITY
       **COMMIT PREPARED **is a PostgreSQL extension. It is intended for use by external transaction
       management systems, some of which are covered by standards (such as X/Open XA), but the SQL
       side of those systems is not standardized.

## SEE ALSO
       PREPARE TRANSACTION ([**PREPARE_TRANSACTION**(7)](https://www.chedong.com/phpMan.php/man/PREPARETRANSACTION/7/markdown)), ROLLBACK PREPARED ([**ROLLBACK_PREPARED**(7)](https://www.chedong.com/phpMan.php/man/ROLLBACKPREPARED/7/markdown))

PostgreSQL 16.14                                2026                              _COMMIT_ [_PREPARED_(7)](https://www.chedong.com/phpMan.php/man/PREPARED/7/markdown)