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…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…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…delete rows of a table NAME DELETE - delete rows of a table SYNOPSIS [ WITH [ RECURSIVE ] with_query [, ...] ] DELETE FROM [ ONLY ] table_name [ * ] [ [ AS ] alias ] [ USING from_i…compute a set of rows NAME VALUES - compute a set of rows SYNOPSIS VALUES ( expression [, ...] ) [, ...] [ ORDER BY sort_expression [ ASC | DESC | USING operator ] [, ...] ] [ LIMI…show the execution plan of a statement NAME EXPLAIN - show the execution plan of a statement SYNOPSIS EXPLAIN [ ( option [, ...] ) ] statement where option can be one of: ANALYZE […define a new row-level security policy for a table NAME CREATE_POLICY - define a new row-level security policy for a table SYNOPSIS CREATE POLICY name ON table_name [ AS { PERMISSI…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 =…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 …create new rows in a table NAME INSERT - create new rows in a table SYNOPSIS [ WITH [ RECURSIVE ] with_query [, ...] ] INSERT INTO table_name [ AS alias ] [ ( column_name [, ...] )…define a cursor NAME DECLARE - define a cursor SYNOPSIS DECLARE name [ BINARY ] [ ASENSITIVE | INSENSITIVE ] [ [ NO ] SCROLL ] CURSOR [ { WITH | WITHOUT } HOLD ] FOR query DESCRIPT…define a new table NAME CREATE_TABLE - define a new table SYNOPSIS CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [ { column_nam…position a cursor NAME MOVE - position a cursor SYNOPSIS MOVE [ direction ] [ FROM | IN ] cursor_name where direction can be one of: NEXT PRIOR FIRST LAST ABSOLUTE count RELATIVE c…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…define a new view NAME CREATE_VIEW - define a new view SYNOPSIS CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ] [ WITH ( view_option_…cluster a table according to an index NAME CLUSTER - cluster a table according to an index SYNOPSIS CLUSTER [ ( option [, ...] ) ] [ table_name [ USING index_name ] ] where option …replace the contents of a materialized view NAME REFRESH_MATERIALIZED_VIEW - replace the contents of a materialized view SYNOPSIS REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] name [ …change the definition of a function NAME ALTER_FUNCTION - change the definition of a function SYNOPSIS ALTER FUNCTION name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] actio…collect statistics about a database NAME ANALYZE - collect statistics about a database SYNOPSIS ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, ...] ] where option can be one…change the definition of a routine NAME ALTER_ROUTINE - change the definition of a routine SYNOPSIS ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ …