Deep Copy ​

After data is imported, you can perform a deep copy to modify a partition key, change a row-store table to a column-store table, or add a partial cluster key. A deep copy re-creates a table and batch inserts data into the table.

openGauss provides three deep copy methods.

• Performing a Deep Copy by Using the CREATE TABLE Statement

• Performing a Deep Copy by Using the CREATE TABLE LIKE Statement

• Performing a Deep Copy by Creating a Temporary Table and Truncating the Original Table