Compressed unload and reload

Deployment options: IBM Netezza Appliance IBM Netezza Appliance

To back up and restore tables when you are using named pipes, or to run your own incremental or table-level backups, you can use the CREATE EXTERNAL TABLE command. Use the command to insert compressed binary format records into an external table from a source table that has the same table schema (table definition).