Character String Literals
By default, string literals ('...'
) treat back slashes literally, as specified in the SQL standard.
Tip: If you have used previous releases of Vertica and you do not want string literals to treat back slashes literally (for example, you are using a back slash as part of an escape sequence), you can turn off the StandardConformingStrings
configuration parameter. See Internationalization Parameters in the Administrator's Guide. You can also use the EscapeStringWarning
parameter to locate back slashes which have been incorporated into string literals, in order to remove them.
See Character String Literals for details.