roll back to a savepoint NAME ROLLBACK_TO_SAVEPOINT - roll back to a savepoint SYNOPSIS ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] save......IT (7), RELEASE SAVEPOINT ( RELEASE_SAVEPOINT (7)), ROLLBACK (7), ROLLBACK TO SAVEPOINT ( ROLLBACK_TO_SAVEPOINT (7))...oint when the transaction is in an aborted state; to do that, use ROLLBACK TO SAVEPOINT ( ROLLBACK_TO_SAVEPOINT (7)). If multiple savepoints have the same name, only the most re…start a transaction block NAME BEGIN - start a transaction block SYNOPSIS BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ] where transaction_mode is one of: ISOLATION LEVE…...ACTION is a PostgreSQL extension. SEE ALSO BEGIN (7), COMMIT (7), ROLLBACK TO SAVEPOINT ( ROLLBACK_TO_SAVEPOINT (7))close a cursor NAME CLOSE - close a cursor SYNOPSIS CLOSE { name | ALL } DESCRIPTION CLOSE frees the resources associated with an open cursor. After the cursor is closed, no subseq…start a transaction block NAME START_TRANSACTION - start a transaction block SYNOPSIS START TRANSACTION [ transaction_mode [, ...] ] where transaction_mode is one of: ISOLATION LEV…change a run-time parameter NAME SET - change a run-time parameter SYNOPSIS SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | ' value ' | DEFAULT } SET [ SESSION…update rows of a table NAME UPDATE - update rows of a table SYNOPSIS [ WITH [ RECURSIVE ] with_query [, ...] ] UPDATE [ ONLY ] table_name [ * ] [ [ AS ] alias ] SET { column_name =…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…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…abort the current transaction NAME ABORT - abort the current transaction SYNOPSIS ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] DESCRIPTION ABORT rolls back the current transac…commit the current transaction NAME END - commit the current transaction SYNOPSIS END [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] DESCRIPTION END commits the current transaction. A…commit the current transaction NAME COMMIT - commit the current transaction SYNOPSIS COMMIT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] DESCRIPTION COMMIT commits the current trans…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…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…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 procedure NAME CREATE_PROCEDURE - define a new procedure SYNOPSIS CREATE [ OR REPLACE ] PROCEDURE name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_ex…retrieve rows from a table or view NAME SELECT, TABLE, WITH - retrieve rows from a table or view SYNOPSIS [ WITH [ RECURSIVE ] with_query [, ...] ] SELECT [ ALL | DISTINCT [ ON ( e…define a cursor NAME DECLARE - define a cursor SYNOPSIS DECLARE name [ BINARY ] [ ASENSITIVE | INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR query DESCRIPT…