Example 4 – Create a writable external table with a 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 4 – Create a writable external table with a \r\n line delimiter

CREATE WRITABLE EXTERNAL TABLE students_out (
name varchar(20), address varchar(30), age int)
LOCATION ('gpfdist://<host>:<portNum>/file/path/')     
FORMAT 'CUSTOM' (formatter=fixedwidth_out, 
        name=20, address=30, age=4, line_delim=E'\r\n');