prepare the current transaction for two-phase commit NAME PREPARE_TRANSACTION - prepare the current transaction for two-phase commit SYNOPSIS PREPARE TRANSACTION trans......A), but the SQL side of those systems is not standardized. SEE ALSO PREPARE TRANSACTION ( PREPARE_TRANSACTION (7)), ROLLBACK PREPARED ( ROLLBACK_PREPARED (7))...A), but the SQL side of those systems is not standardized. SEE ALSO PREPARE TRANSACTION ( PREPARE_TRANSACTION (7)), COMMIT PREPARED ( COMMIT_PREPARED (7))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…define a new subscription NAME CREATE_SUBSCRIPTION - define a new subscription SYNOPSIS CREATE SUBSCRIPTION subscription_name CONNECTION ' conninfo ' PUBLICATION publication_name […define a new table from the results of a query NAME CREATE_TABLE_AS - define a new table from the results of a query SYNOPSIS CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNL…set the characteristics of the current transaction NAME SET_TRANSACTION - set the characteristics of the current transaction SYNOPSIS SET TRANSACTION transaction_mode [, ...] SET T…start a transaction block NAME BEGIN - start a transaction block SYNOPSIS BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ] where transaction_mode is one of: ISOLATION LEVE…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…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 cursor NAME DECLARE - define a cursor SYNOPSIS DECLARE name [ BINARY ] [ ASENSITIVE | INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR query DESCRIPT…rebuild indexes NAME REINDEX - rebuild indexes SYNOPSIS REINDEX [ ( option [, ...] ) ] { INDEX | TABLE | SCHEMA } [ CONCURRENTLY ] name REINDEX [ ( option [, ...] ) ] { DATABASE | …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…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…remove an index NAME DROP_INDEX - remove an index SYNOPSIS DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DESCRIPTION DROP INDEX drops an existing in…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 …start a transaction block NAME START_TRANSACTION - start a transaction block SYNOPSIS START TRANSACTION [ transaction_mode [, ...] ] where transaction_mode is one of: ISOLATION LEV…