The gadget spec URL could not be found
1. COPY TO: Copy to command is quick and easy postgresql way to unload data. For example COPY ( SELECT * FROM sales) TO ‘/tmp/sales.dat’; The gadget spec URL could not be found Advantage:
The gadget spec URL could not be found The gadget spec URL could not be found 2. External Writeable: The advantage of Greenplum writable external table are,
Allows only INSERT operations Unload Using a File Based Writable External Table =# CREATE WRITABLE EXTERNAL TABLE unload_expenses ( LIKE expenses ) LOCATION ('gpfdist://etlhost-1:8081/expenses1.out', 'gpfdist://etlhost-2:8081/expenses2.out') FORMAT 'TEXT' (DELIMITER ',') DISTRIBUTED BY (exp_id); psql –c ‘INSERT INTO unload_expenses SELECT * FROM expenses;’ The gadget spec URL could not be found Unload Using a Writable External Web Table Command based – Use EXECUTE to specify a shell command, script, or application =# CREATE WRITABLE EXTERNAL WEB TABLE output (output text) EXECUTE 'export PATH=$PATH:/home/gpadmin/programs; myprogram.sh' FORMAT 'TEXT' DISTRIBUTED RANDOMLY; The gadget spec URL could not be found 3. gpcrondump: backup data using Greenplum crondump which dmps database into SQL script files then restore. For example, gpcrondump -x sachi | The gadget spec URL could not be found The gadget spec URL could not be found |
The gadget spec URL could not be found