Unloading Data from Greenplum Database

A writable external table allows you to select rows from other database tables and output the rows to files, named pipes, to applications. You can define file-based and web-based writable external tables.

This topic describes how to unload data from Greenplum Database using parallel unload (writable external tables) and non-parallel unload (COPY).

• Defining a File-Based Writable External Table

• Defining a Command-Based Writable External Web Table

• Unloading Data Using a Writable External Table

• Unloading Data Using COPY

• Unloading File Data Using Greenplum Streaming Server

Parent topic: Loading and Unloading Data