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…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…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 cursor NAME DECLARE - define a cursor SYNOPSIS DECLARE name [ BINARY ] [ ASENSITIVE | INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR query DESCRIPT…set constraint check timing for the current transaction NAME SET_CONSTRAINTS - set constraint check timing for the current transaction SYNOPSIS SET CONSTRAINTS { ALL | name [, ...]…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 …change a run-time parameter NAME SET - change a run-time parameter SYNOPSIS SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | ' value ' | DEFAULT } SET [ SESSION…change the definition of a sequence generator NAME ALTER_SEQUENCE - change the definition of a sequence generator SYNOPSIS ALTER SEQUENCE [ IF EXISTS ] name [ AS data_type ] [ INCR…