start a transaction block NAME START_TRANSACTION - start a transaction block SYNOPSIS START TRANSACTION [ transaction_mode [, ...] ] where...prepare the current transaction for two-phase commit NAME PREPARE_TRANSACTION - prepare the current transaction for two-phase commit SYNOPSIS PREPARE TRANSACTION transaction_id DES…...hen porting database applications. SEE ALSO COMMIT (7), ROLLBACK (7), START TRANSACTION ( START_TRANSACTION (7)), SAVEPOINT (7)set the characteristics of the current transaction NAME SET_TRANSACTION - set the characteristics of the current transaction SYNOPSIS SET TRANSACTION transaction_mode [, ...] SET T…empty a table or set of tables NAME TRUNCATE - empty a table or set of tables SYNOPSIS TRUNCATE [ TABLE ] [ ONLY ] name [ * ] [, ... ] [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CA…roll back to a savepoint NAME ROLLBACK_TO_SAVEPOINT - roll back to a savepoint SYNOPSIS ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] savepoint_name DESCRIPTION Roll back all co…Update the object name stored in a ref safely NAME git-update-ref - Update the object name stored in a ref safely SYNOPSIS git update-ref [-m <reason>] [--no-deref] (-d <ref> [<old…control PostgreSQL logical decoding streams NAME pg_recvlogical - control PostgreSQL logical decoding streams SYNOPSIS pg_recvlogical [ option ...] DESCRIPTION pg_recvlogical contr…restore the value of a run-time parameter to the default value NAME RESET - restore the value of a run-time parameter to the default value SYNOPSIS RESET configuration_parameter RE…rebuild indexes NAME REINDEX - rebuild indexes SYNOPSIS REINDEX [ ( option [, ...] ) ] { INDEX | TABLE | SCHEMA } [ CONCURRENTLY ] name REINDEX [ ( option [, ...] ) ] { DATABASE | …generate a notification NAME NOTIFY - generate a notification SYNOPSIS NOTIFY channel [ , payload ] DESCRIPTION The NOTIFY command sends a notification event together with an optio…lock a table NAME LOCK - lock a table SYNOPSIS LOCK [ TABLE ] [ ONLY ] name [ * ] [, ...] [ IN lockmode MODE ] [ NOWAIT ] where lockmode is one of: ACCESS SHARE | ROW SHARE | ROW E…define a new subscription NAME CREATE_SUBSCRIPTION - define a new subscription SYNOPSIS CREATE SUBSCRIPTION subscription_name CONNECTION ' conninfo ' PUBLICATION publication_name […change the definition of a subscription NAME ALTER_SUBSCRIPTION - change the definition of a subscription SYNOPSIS ALTER SUBSCRIPTION name CONNECTION ' conninfo ' ALTER SUBSCRIPTIO…commit a transaction that was earlier prepared for two-phase commit NAME COMMIT_PREPARED - commit a transaction that was earlier prepared for two-phase commit SYNOPSIS COMMIT PREPA…cancel a transaction that was earlier prepared for two-phase commit NAME ROLLBACK_PREPARED - cancel a transaction that was earlier prepared for two-phase commit SYNOPSIS ROLLBACK P…a database backup program (mariadb-dump is now a symlink to mariadb-dump) NAME mariadb-dump - a database backup program (mariadb-dump is now a symlink to mariadb-dump) SYNOPSIS mar…a database backup program (mariadb-dump is now a symlink to mariadb-dump) NAME mariadb-dump - a database backup program (mariadb-dump is now a symlink to mariadb-dump) SYNOPSIS mar…MySQL and InnoDB transaction/status monitor. NAME innotop - MySQL and InnoDB transaction/status monitor. SYNOPSIS To monitor servers normally: innotop To monitor InnoDB status info…listen for a notification NAME LISTEN - listen for a notification SYNOPSIS LISTEN channel DESCRIPTION LISTEN registers the current session as a listener on the notification channel…