set the characteristics of the current transaction NAME SET_TRANSACTION - set the characteristics of the current transaction SYNOPSIS SET TRANSACTION transaction...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…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…...TERS WORK TRANSACTION Optional key words. They have no effect. Refer to SET TRANSACTION ( SET_TRANSACTION (7)) for information on the meaning of the other parameters to this sta…...y concurrency levels on transactions. PostgreSQL supports that too; see SET TRANSACTION ( SET_TRANSACTION (7)) for details. Except for ACCESS SHARE, ACCESS EXCLUSIVE, and SHARE …generate a notification NAME NOTIFY - generate a notification SYNOPSIS NOTIFY channel [ , payload ] DESCRIPTION The NOTIFY command sends a notification event together with an optio…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…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…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…define a new subscription NAME CREATE_SUBSCRIPTION - define a new subscription SYNOPSIS CREATE SUBSCRIPTION subscription_name CONNECTION ' conninfo ' PUBLICATION publication_name […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…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…change the definition of a subscription NAME ALTER_SUBSCRIPTION - change the definition of a subscription SYNOPSIS ALTER SUBSCRIPTION name CONNECTION ' conninfo ' ALTER SUBSCRIPTIO…rebuild indexes NAME REINDEX - rebuild indexes SYNOPSIS REINDEX [ ( option [, ...] ) ] { INDEX | TABLE | SCHEMA } [ CONCURRENTLY ] name REINDEX [ ( option [, ...] ) ] { DATABASE | …define a cursor NAME DECLARE - define a cursor SYNOPSIS DECLARE name [ BINARY ] [ ASENSITIVE | INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR query DESCRIPT…control PostgreSQL logical decoding streams NAME pg_recvlogical - control PostgreSQL logical decoding streams SYNOPSIS pg_recvlogical [ option ...] DESCRIPTION pg_recvlogical contr…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…conditionally insert, update, or delete rows of a table NAME MERGE - conditionally insert, update, or delete rows of a table SYNOPSIS [ WITH with_query [, ...] ] MERGE INTO [ ONLY …