Escaping in Text Formatted Files

    For example, suppose you have a table with three columns and you want to load the following three fields:

    Notice how the backslash character that is part of the data is escaped with another backslash character, and the pipe character that is part of the data is escaped with a backslash character.

    You can deactivate escaping in -formatted files using the ESCAPE clause of COPY, CREATE EXTERNAL TABLEor gpload as follows:

      Parent topic: Escaping