Postgres support (other statements)

[nene]

Other

• ANALYZE
  • plain ANALYZE
  • multiple tables
  • optional columns lists
  • VERBOSE
  • options:
    • VERBOSE [ boolean ]
    • SKIP_LOCKED [ boolean ]
    • BUFFER_USAGE_LIMIT size
• EXPLAIN
  • Basic EXPLAIN statement
  • EXPLAIN ANALYZE
  • EXPLAIN VERBOSE
  • options:
    • ANALYZE [ boolean ]
    • VERBOSE [ boolean ]
    • COSTS [ boolean ]
    • SETTINGS [ boolean ]
    • GENERIC_PLAN [ boolean ]
    • BUFFERS [ boolean ]
    • WAL [ boolean ]
    • TIMING [ boolean ]
    • SUMMARY [ boolean ]
    • FORMAT { TEXT | XML | JSON | YAML }
• PREPARE
  • PREPARE name AS statement
  • PREPARE name (data_type, ...) AS statement
• EXECUTE
  • EXECUTE name
  • EXECUTE name (parameter, ...)
• DEALLOCATE [ PREPARE ] { name | ALL }
• CALL name ( arg, ...)
• DO [ LANGUAGE lang_name ] code
• DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP }
• CHECKPOINT
• CLUSTER [ ( option [, ...] ) ] [ table_name [ USING index_name ] ]
  • VERBOSE [ boolean ]
• LISTEN channel
• LOAD 'filename'
• LOCK
  • [ TABLE ]
  • [ ONLY ]
  • name [ * ] [, ...]
  • [ IN lockmode MODE ] where lockmode is one of:
    • ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE | SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVE
  • [ NOWAIT ]
• NOTIFY channel [ , payload ]
• REINDEX [ name ]
  • [ ( option [, ...] ) ] where option can be one of:
    • CONCURRENTLY [ boolean ]
    • TABLESPACE new_tablespace
    • VERBOSE [ boolean ]
  • { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM }
  • [ CONCURRENTLY ]
• RESET configuration_parameter | ALL
• SET
  • SET configuration_parameter { TO | = } { value | 'value' | DEFAULT }
  • SET TIME ZONE { value | 'value' | LOCAL | DEFAULT }
  • [ SESSION | LOCAL ]
• SHOW { name | ALL }
• UNLISTEN { channel | * }

Undocumented syntax

• In INSERT INTO ... ON CONFLICT clause one can use opclass (as documented)
  • followed by parenthesized list of rel-options (not documented for INSERT INTO, but as documented for CREATE INDEX)