By default, the escape character is a \ (backslash) for text-formatted files. You can declare a different escape character in the ESCAPE clause of COPY , CREATE EXTERNAL TABLE or...
Full-text query types and options Query types Match Multi-match Match Boolean prefix Match phrase Match phrase prefix Query string Simple query string Match all Advanced f...
Description Synopsis Description Parameters Compatibility See Also Description Changes the definition of a text search parser. Synopsis ALTER TEXT SEARCH PARSER <name> ...
Synopsis Description Parameters Examples Compatibility See Also Changes the definition of a text search configuration. Synopsis ALTER TEXT SEARCH CONFIGURATION <name> ...
Full-text search Match Syntax Example 1: Search the message field for the text “this is a test”: Example 2: Search the message field with the operator parameter: Example 3: S...
Full-text search Match Syntax Multi match Query string Match phrase Score query Full-text search Use SQL commands for full-text search. The SQL plugin supports a subset of...
Full-text queries Match Match boolean prefix Match phrase Match phrase prefix Query string Simple query string Match all Match none Convert text with analyzers Sample Reque...
Add a text box variable Enter General options Enter Text options Add a text box variable Text box variables display a free text input field with an optional default value. Thi...
Add a text box variable Enter General options Enter Text options Add a text box variable Text box variables display a free text input field with an optional default value. Thi...
Full-text search Match Syntax Multi match Query string Match phrase Score query Full-text search Use SQL commands for full-text search. The SQL plugin supports a subset of...