Example 3 – Loading data with no line delimiter

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 3 – Loading data with no line delimiter

CREATE READABLE EXTERNAL TABLE students (
name varchar(20), address varchar(30), age int)
LOCATION ('file://<host>/file/path/')
FORMAT 'CUSTOM' (formatter=fixedwidth_in, 
         name='20', address='30', age='4', line_delim='?@')