define a new transform NAME CREATE_TRANSFORM - define a new transform SYNOPSIS CREATE [ OR REPLACE ] TRANSFORM FOR type_name LANGUAGE lang_name ( FROM SQL WITH FUNCTION from_sql_fu…define a new procedure NAME CREATE_PROCEDURE - define a new procedure SYNOPSIS CREATE [ OR REPLACE ] PROCEDURE name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_ex…define a new function NAME CREATE_FUNCTION - define a new function SYNOPSIS CREATE [ OR REPLACE ] FUNCTION name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ]…define a cursor NAME DECLARE - define a cursor SYNOPSIS DECLARE name [ BINARY ] [ ASENSITIVE | INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR query DESCRIPT…deallocate a prepared statement NAME DEALLOCATE - deallocate a prepared statement SYNOPSIS DEALLOCATE [ PREPARE ] { name | ALL } DESCRIPTION DEALLOCATE is used to deallocate a prev…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…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…set the session user identifier and the current user identifier of the current session NAME SET_SESSION_AUTHORIZATION - set the session user identifier and the current user identif…set the characteristics of the current transaction NAME SET_TRANSACTION - set the characteristics of the current transaction SYNOPSIS SET TRANSACTION transaction_mode [, ...] SET T…set the current user identifier of the current session NAME SET_ROLE - set the current user identifier of the current session SYNOPSIS SET [ SESSION | LOCAL ] ROLE role_name SET [ …define access privileges NAME GRANT - define access privileges SYNOPSIS GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN } [, ...] | ALL [ P…define a new trigger NAME CREATE_TRIGGER - define a new trigger SYNOPSIS CREATE [ OR REPLACE ] [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] } ON t…define a new schema NAME CREATE_SCHEMA - define a new schema SYNOPSIS CREATE SCHEMA schema_name [ AUTHORIZATION role_specification ] [ schema_element [ ... ] ] CREATE SCHEMA AUTHOR…define a new encoding conversion NAME CREATE_CONVERSION - define a new encoding conversion SYNOPSIS CREATE [ DEFAULT ] CONVERSION name FOR source_encoding TO dest_encoding FROM fun…retrieve rows from a query using a cursor NAME FETCH - retrieve rows from a query using a cursor SYNOPSIS FETCH [ direction ] [ FROM | IN ] cursor_name where direction can be one o…abort the current transaction NAME ABORT - abort the current transaction SYNOPSIS ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ] DESCRIPTION ABORT rolls back the current transac…define a new table from the results of a query NAME SELECT_INTO - define a new table from the results of a query SYNOPSIS [ WITH [ RECURSIVE ] with_query [, ...] ] SELECT [ ALL | D…remove a data type NAME DROP_TYPE - remove a data type SYNOPSIS DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DESCRIPTION DROP TYPE removes a user-defined data type. …remove a trigger NAME DROP_TRIGGER - remove a trigger SYNOPSIS DROP TRIGGER [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ] DESCRIPTION DROP TRIGGER removes an existing tri…start a transaction block NAME START_TRANSACTION - start a transaction block SYNOPSIS START TRANSACTION [ transaction_mode [, ...] ] where transaction_mode is one of: ISOLATION LEV…