Creates a readable external table, ext_expenses, using the gpfdist protocol from all files with the txt extension. The column delimiter is a pipe ( | ) and NULL (’ ’) is a space.

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

Parent topic: Examples for Creating External Tables