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…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…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 …...as executed. This is the same as the BEGIN command. PARAMETERS Refer to SET TRANSACTION ( SET_TRANSACTION (7)) for information on the meaning of the parameters to this statement…...n is immediately started with the same transaction characteristics (see SET TRANSACTION ( SET_TRANSACTION (7))) as the just finished one. Otherwise, no new transaction is starte…...n is immediately started with the same transaction characteristics (see SET TRANSACTION ( SET_TRANSACTION (7))) as the just finished one. Otherwise, no new transaction is starte…remove a database NAME DROP_DATABASE - remove a database SYNOPSIS DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ] where option can be: FORCE DESCRIPTION DROP DATAB…