The COPY CLUSTER statement is used to copy data from one cluster to another. By default, COPY CLUSTER copies only the current record from the source to the destination. However, there are options to copy all records from the source cluster to the target cluster.

The ALL and APPEND parameters are available to use with the COPY CLUSTER statement.

• ALL -- copies all rows starting with row one of the cluster source to the corresponding destination cluster array row.
• APPEND -- copies all rows starting with row one of the source cluster, appending each row to the end of the destination cluster.