COPY

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

COPY

The COPY command is the standard PostgreSQL non-parallel data loading tool.

Greenplum Database offers the standard PostgreSQL COPY command for loading and unloading data. COPY is a non-parallel load/unload mechanism: data is loaded/unloaded in a single process using the Greenplum master database instance. For small amounts of data, COPY offers a simple way to move data into or out of a database in a single transaction, without the administrative overhead of setting up an external table.