kingbase闪回表到指定时间点

jiawang

创建测试表及数据
test=# create table tss(a int,b varchar(30));
CREATE TABLE
test=# insert into tss values(1,'a');
INSERT 0 1
test=# \set 'tp2' `date "+%Y-%m-%d %H:%M:%S.%N"`
test=# select * from tss;
a | b
---+---
1 | a
(1 行记录)


test=# insert into tss values(2,'b');
INSERT 0 1
test=# \set 'tp3' `date "+%Y-%m-%d %H:%M:%S.%N"`
test=# delete from tss;
DELETE 2
test=# \set 'tp4' `date "+%Y-%m-%d %H:%M:%S.%N"`
test=# select * from
test-#  tss;
a | b
---+---
(0 行记录)

登录/注册后可看大图