Creates a readable external table, ext_expenses, using the gpfdist protocol. The files are formatted with a pipe (|) as the column delimiter.

    1. =# CREATE EXTERNAL TABLE ext_expenses ( name text,
    2.     date date, amount float4, category text, desc1 text )
    3.     LOCATION ('gpfdist://etlhost-1:8081/*')
    4. FORMAT 'TEXT' (DELIMITER '|');

    Parent topic: Examples for Creating External Tables