云数据库 GaussDB-TIMECAPSULE TABLE:示例

时间：2025-02-12 15:06:01

云数据库 GaussDB

示例

-- 创建SCHEMAgaussdb=# CREATE SCHEMA tpcds;-- 删除表tpcds.reason_t2DROP TABLE IF EXISTS tpcds.reason_t2;-- 创建表tpcds.reason_t2gaussdb=# CREATE TABLE tpcds.reason_t2 (  r_reason_sk    integer,  r_reason_id    character(16),  r_reason_desc  character(100)  )with(storage_type = ustore);--向表tpcds.reason_t2中插入记录gaussdb=#  INSERT INTO tpcds.reason_t2 VALUES (1, 'AA', 'reason1'),(2, 'AB', 'reason2'),(3, 'AC', 'reason3');INSERT 0 3--清空tpcds.reason_t2表中的数据gaussdb=#  TRUNCATE TABLE tpcds.reason_t2;--查询tpcds.reason_t2表中的数据gaussdb=#  select * from tpcds.reason_t2; r_reason_sk | r_reason_id | r_reason_desc -------------+-------------+---------------(0 rows)--执行闪回TRUNCATEgaussdb=#  TIMECAPSULE TABLE tpcds.reason_t2 to BEFORE TRUNCATE;gaussdb=#  select * from tpcds.reason_t2; r_reason_sk |   r_reason_id    |                                            r_reason_desc                                             -------------+------------------+------------------------------------------------------------------------------------------------------           1 | AA               | reason1                                                                                                        2 | AB               | reason2                                                                                                        3 | AC               | reason3                                                                                             (3 rows)--删除表tpcds.reason_t2gaussdb=#  DROP TABLE tpcds.reason_t2;--执行闪回DROPgaussdb=#  TIMECAPSULE TABLE tpcds.reason_t2 to BEFORE DROP;TimeCapsule Table--执行闪回DROP，为检索表指定新名称gaussdb=#  TIMECAPSULE TABLE tpcds.reason_t2 TO BEFORE DROP rename to reason_t3;TimeCapsule Table-- 清空回收站，删除SCHEMAgaussdb=# PURGE RECYCLEBIN;gaussdb=# DROP SCHEMA tpcds CASCADE;