Example 2 – Loading a table with PRESERVED_BLANKS ON

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

Example 2 – Loading a table with PRESERVED_BLANKS ON

CREATE READABLE EXTERNAL TABLE students (
name varchar(20), address varchar(30), age int)
LOCATION ('gpfdist://<host>:<portNum>/file/path/')
FORMAT 'CUSTOM' (formatter=fixedwidth_in, 
         name=20, address=30, age=4,
        preserve_blanks='on',null='NULL');