Tanzu Greenplum 5

Example 7—Readable External Web Table with Script

Last Updated February 12, 2025

Creates a readable external web table that executes a script once per segment host:

=# CREATE EXTERNAL WEB TABLE log_output (linenum int, 
    message text) 
   EXECUTE '/var/load_scripts/get_log_data.sh' ON HOST 
   FORMAT 'TEXT' (DELIMITER '|');

Parent topic: Examples for Creating External Tables