Loading Data with COPY

This version of the Pivotal Greenplum documentation is no longer actively maintained. Click here to view the most up-to-date version of the Greenplum 4.x documentation.

Loading Data with COPY

COPY FROM copies data from a file or standard input into a table and appends the data to the table contents. COPY is non-parallel: data is loaded in a single process using the Greenplum master instance. Using COPY is only recommended for very small data files.

The COPY source file must be accessible to the master host. Specify the COPY source file name relative to the master host location.

Greenplum copies data from STDIN or STDOUT using the connection between the client and the master server.