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.
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
STDOUT using the connection between the client and the master server.
Parent topic: Loading and Unloading Data