Postgres support (other statements)

[nene]

Other

• [ ] ANALYZE
  • [x] plain ANALYZE
  • [x] multiple tables
  • [ ] optional columns lists
  • [ ] VERBOSE
  • [ ] options:
    • [ ] VERBOSE [ boolean ]
    • [ ] SKIP_LOCKED [ boolean ]
    • [ ] BUFFER_USAGE_LIMIT size
• [ ] EXPLAIN
  • [x] Basic EXPLAIN statement
  • [x] 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 }
• [x] CALL name ( arg, ...)
• [x] 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)