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 }
• 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 ]
• 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)