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