云数据库 GaussDB-闪回表:使用示例

时间：2025-02-12 15:05:24

云数据库 GaussDB

使用示例

gaussdb=# DROP TABLE IF EXISTS "public".flashtest;NOTICE:  table "flashtest" does not exist, skippingDROP TABLE--创建表gaussdb=# CREATE TABLE "public".flashtest (col1 INT,col2 TEXT) with(storage_type=ustore);NOTICE:  The 'DISTRIBUTE BY' clause is not specified. Using 'col1' as the distribution column by default.HINT:  Please use 'DISTRIBUTE BY' clause to specify suitable data distribution column.CREATE TABLE--查询csngaussdb=# SELECT int8in(xidout(next_csn)) FROM gs_get_next_xid_csn();  int8in  ---------- 79352065 79352065 79352065 79352065 79352065 79352065(6 rows)--查询当前的时间戳gaussdb=# SELECT now();              now              ------------------------------- 2023-09-13 19:46:34.102863+08(1 row)--查看表flashtestgaussdb=# SELECT * FROM flashtest; col1 | col2 ------+------(0 rows)--插入数据gaussdb=# INSERT INTO flashtest VALUES(1,'INSERT1'),(2,'INSERT2'),(3,'INSERT3'),(4,'INSERT4'),(5,'INSERT5'),(6,'INSERT6');INSERT 0 6gaussdb=# SELECT * FROM flashtest; col1 |  col2   ------+---------    3 | INSERT3    1 | INSERT1    2 | INSERT2    4 | INSERT4    5 | INSERT5    6 | INSERT6(6 rows)--闪回表至特定csngaussdb=# TIMECAPSULE TABLE flashtest TO  CS N 79352065;TimeCapsule Tablegaussdb=# SELECT * FROM flashtest; col1 | col2 ------+------(0 rows)gaussdb=# SELECT now();              now              ------------------------------- 2023-09-13 19:52:21.551028+08(1 row)--插入数据gaussdb=# INSERT INTO flashtest VALUES(1,'INSERT1'),(2,'INSERT2'),(3,'INSERT3'),(4,'INSERT4'),(5,'INSERT5'),(6,'INSERT6');INSERT 0 6gaussdb=# SELECT * FROM flashtest; col1 |  col2   ------+---------    3 | INSERT3    6 | INSERT6    1 | INSERT1    2 | INSERT2    4 | INSERT4    5 | INSERT5(6 rows)--闪回表至特定的时间戳gaussdb=# TIMECAPSULE TABLE flashtest TO TIMESTAMP to_timestamp ('2023-09-13 19:52:21.551028', 'YYYY-MM-DD HH24:MI:SS.FF');TimeCapsule Tablegaussdb=# SELECT * FROM flashtest; col1 | col2 ------+------(0 rows)gaussdb=# select now();              now              ------------------------------- 2023-09-13 19:54:00.641506+08(1 row)--插入数据gaussdb=# INSERT INTO flashtest VALUES(1,'INSERT1'),(2,'INSERT2'),(3,'INSERT3'),(4,'INSERT4'),(5,'INSERT5'),(6,'INSERT6');INSERT 0 6gaussdb=# SELECT * FROM flashtest; col1 |  col2   ------+---------    3 | INSERT3    6 | INSERT6    1 | INSERT1    2 | INSERT2    4 | INSERT4    5 | INSERT5(6 rows)--闪回表至特定的时间戳gaussdb=# TIMECAPSULE TABLE flashtest TO TIMESTAMP '2023-09-13 19:54:00.641506';TimeCapsule Tablegaussdb=# SELECT * FROM flashtest; col1 | col2 ------+------(0 rows)gaussdb=# DROP TABLE IF EXISTS "public".flashtest;DROP TABLE

上一篇：云数据库 GaussDB-分区表（母表）

下一篇：云数据库 GaussDB-分区表（母表）