Change the query delimiter from the default semicolon ';' to any non-reserved character. It must be followed by a valid SQL query.

Syntax

DELIMITER (character)

Examples

Specify a different delimiter for scripts which include nested queries.

DELIMITER @

BEGIN
  PARALLEL 4
  GROUPED
  ON ERROR CANCEL;
  DATACOPY
  "dataxchange"."postgres"."public"."doctest"
   to "dataxchange"."postgres"."public"."doctest2"
   WITH CREATE NOCONSTRAINTS;
END @