Example 9—Writable External Web Table with Script

Creates a writable external web table, campaign_out, that pipes output data received by the segments to an executable script, to_adreport_etl.sh:

  1. =# CREATE WRITABLE EXTERNAL WEB TABLE campaign_out
  2.     (LIKE campaign)
  3.     EXECUTE '/var/unload_scripts/to_adreport_etl.sh'
  4.     FORMAT 'TEXT' (DELIMITER '|');

Parent topic: Examples for Creating External Tables