重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: kingbase闪回表到指定时间点 [打印本页]

---

作者: jiawang    时间: 2026-3-19 09:42
标题: kingbase闪回表到指定时间点


创建测试表及数据
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 行记录)

登录/注册后可看大图