Deactivating EXECUTE for Web or Writable External Tables

There is a security risk associated with allowing external tables to execute OS commands or scripts. To deactivate the use of EXECUTE in web and writable external table definitions, set the gp_external_enable_exec server configuration parameter to off in your master postgresql.conf file:

gp_external_enable_exec = off

Parent topic: Defining a Command-Based Writable External Web Table

check-circle-line exclamation-circle-line close-line
Scroll to top icon