Importing and Exporting Fixed Width Data

    The following options specify how to import fixed width data.

    • Read all the data.

    • Set options for blank and null characters.

      Trailing blanks are trimmed by default. To keep trailing blanks, use the option.You can reset the trailing blanks option to the default with the preserve_blanks=off option.

    • If you specify preserve_blanks=off, null is not defined, and the field contains only blanks, HAWQ writes a null to the table. If null is defined, HAWQ writes an empty string to the table.

      1. line_delim=E'\n'
      2. line_delim=E'\r\n'