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.