Unloading Data Using COPY

COPY TO copies data from a table to a file (or standard input) on the HAWQ master host using a single process on the HAWQ master instance. Use COPY to output a table’s entire contents, or filter the output using a SELECT statement. For example: