DELIMITER
Function
DELIMITER defines a delimiter, indicating that the input command ends when the delimiter is encountered. When there are many input statements and semicolons (;) exist in the statements, you can specify a special symbol as the delimiter. By default, the delimiter is a semicolon (;).
Precautions
Currently, the delimiter cannot be set freely. The delimiter can be a keyword, identifier, character string, operator, and semicolon. The common usage is “//”. For details, see the examples.
The delimiter is of the session level, supported only by the gsql client, and available only in B-compatible mode.
Syntax
Define a delimiter.
DELIMITER delimiter_str_name END_OF_INPUT DELIMITER delimiter_str_name END_OF_INPUT_COLON
Parameter Description
delim_str_name
Indicates types of delimiters that can be defined.
END_OF_INPUT/END_OF_INPUT_COLON
Indicates the end status.
Examples
--Define an identifier.
openGauss=# delimiter abcd
--Define a character string.
openGauss=# delimiter "sds;"
--Define an operator.
openGauss=# delimiter +
openGauss=# delimiter /
--Define a default value.
openGauss=# delimtier ;
## Helpful Links
None.
Feedback